Date-Time data type
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.