Choose where you’d like to start

Date-Time data type

Table of ContentsUp

Overview

The date-time datatype represents date and time values in a variety of supported formats.

Note:

  • Date-time values must be enclosed within single quotes.
  • A date can be declared without time, in which case 00:00:00 is taken as the default.

Example

 date = '15-Aug-1947';
 appointment_time = '15-Aug-1947 19:00:00';

Supported Date formats

  • dd-MMM-yy (15-Aug-47)
  • dd-MMM-yyyy (15-Aug-1947)
  • dd-MMMM-yy (15-August-47)
  • dd-MMMM-yyyy (15-August-1947)
  • MM-dd-yy (08-15-47)
  • yy-MM-dd (47-08-15)
  • dd-MM-yy (15-08-47)
  • dd-MM-yyyy (15-08-1947)
  • MM-dd-yyyy (08-15-1947)
  • yyyy-MM-dd (1947-08-15)
  • yy/MM/dd (47/08/15)
  • dd/MM/yy (15/08/47)
  • MM/dd/yy (08/15/47)
  • yyyy/MM/dd (1947/08/15)
  • MM/dd/yyyy (08/15/1947)
  • dd/MM/yyyy (15/08/1947)
  • dd MMM,yy (15 Aug,47)
  • MMM dd,yy (Aug 15,47)
  • dd MMM,yyyy (15 Aug,1947)
  • MMM dd,yyyy (Aug 15,1947)
  • dd MMMM,yy (15 August,47)
  • MMMM dd,yy (August 15,47)
  • dd MMMM,yyyy (15 August,1947)
  • MMMM dd,yyyy (August 15,1947)
  • E,MMMM dd,yyyy (Fri,August 15,1947)
  • E,MMM dd,yyyy (Fri,Aug 15,1947)
  • MMM dd yy (Aug 15 47)
  • dd MMM yy (15 Aug 47)
  • MMM dd yyyy (Aug 15 1947)
  • dd MMM yyyy (15 Aug 1947)
  • MMMM dd yy (August 15 47)
  • dd MMMM yy (15 August 47)
  • dd MMMM yyyy (15 August 1947)
  • MMMM dd yyyy (August 15 1947)
  • dd.MM.yy (15.08.47)
  • MM.dd.yy (08.15.47)
  • yy.MM.dd (47.08.15)
  • dd MM yyyy (15 08 1947)
  • dd.MM.yyyy (15.08.1947)
  • MM.dd.yyyy (08.15.1947)
  • yyyy.MM.dd (1947.08.15)

Note:

  • In the event of mismatch between the specified and supported Date Time formats, we will try to convert the specified format into the closest supported format. In the event of a failure, an error message will be encountered.
  • See this page to find the built-in functions applicable to date-time data type.
  • See this page to know which Zoho Creator field types are of date-time data type.

Get Started Now

Execute