Format String | Description | Example |
yy | Indicates Year without century. If the value is from 70 to 99, the year is taken in the 20th century (1970, 1971... 1999). | 14 (2014) 08 (2008) |
yyyy | Indicates Year with century | 2014 |
MM | Indicates Month in numeric | 3 (March) |
MMM | Indicates Month as a three letter text abbreviation (Jan, Feb, etc.) | Jan |
MMMM | Indicates Month in full text | January |
dd | Indicates Day in the month | 12 |
EEE | Indicates Day in the week (abbreviation) | Wed |
EEEE | Indicates Day in the week (full form) | Wednesday |
HH | Indicates Hours in a day between 0 to 23 hrs | 23:50 |
hh | Indicates Hours in a day between 1 to 12 hrs (morning or afternoon is identified by AM or PM) | 10:30 |
mm | Indicates Minutes in the hour from 01 to 12 | 1:30 |
m | Indicates Minutes in the hour from 1 to 12 | 1:5 |
ss | Indicates Seconds in the minute from 00 to 59 | 11:30:45 |
s | Indicates Seconds in the minute from 0 to 59 | 11:30:5 |
SSS | Indicates the Millisecond in the Date or Time | 11:30:45:163 |
a | Indicates AM/PM of the time | 11:00 AM, 2:00 PM |
ZZ | Indicates the time zone offset with colon separator | Nov 24, 2014 10:00 PM +5:30 |
Z | Indicates the time zone offset without the colon separator | Nov 24, 2014 10:00 PM +0530 |
millis | Indicates number of milliseconds since January 1, 1970. This format is applicable for timestamp data type. | 1635509077 |
Category | Delimiters |
Date time delimiters | / - . , : _T \s |
AM/PM delimiters | \s |
Time zone delimiters | - Z |
Time delimiters | / : - , . \s |
11 | MM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
11 | MM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
2020 | yyyy | Indicates the year |
11 | MM | Indicates the month |
24 | dd | Indicates the day |
November | MMMM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
11 | MM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
11 | MM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
Nov | MMM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
02 | hh | Indicates the hour (0-12) |
47 | mm | Indicates the minute |
PM | a | AM/PM |
Nov | MMM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
14 | HH | Indicates the hour(00-23) |
47 | mm | Indicates the minute |
November | MMMM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
Nov | MMM | Indicates the month |
24 | dd | Indicates the day |
2020 | yyyy | Indicates the year |
02 | hh | Indicates the hour (01-12) |
47 | mm | Indicates the minute |
PM | a | AM/PM |
+5.30 | ZZ | Indicates the time zone |
Wednesday | EEEE | Indicates the weekday |
24 | dd | Indicates the day |
Nov | MMM | Indicates the month |
98 | yy | Indicates the year |
14 | HH | Indicates the hour (00-23) |
47 | mm | Indicates the minutes |
59 | ss | Indicates the seconds |
163 | SSS | Indicates the milliseconds |
21 | HH | Indicates the hours(00-23) |
21 | mm | Indicates the minutes |
01 | ss | Indicates the seconds |
11 | HH | Indicates the hour(00-23) |
21 | mm | Indicates the minutes |
21 | HH | Indicates the hour(00-23) |
21 | mm | Indicates the minutes |
01 | ss | Indicates the seconds |
999 | SSS | Indicates the milliseconds |
11 | hh | Indicates the hour(01-12) |
21 | mm | Indicates the minutes |
01 | ss | Indicates the seconds |
999 | SSS | Indicates the milliseconds |
AM | a | AM/PM |
11 | hh | Indicates the hour(01-12) |
21 | mm | Indicates the minutes |
09 | ss | Indicates the seconds |
PM | a | AM/PM |
12 | hh | Indicates the hour(01-12) |
21 | mm | Indicates the minutes |
PM | a | AM/PM |
11 | hh | Indicates the hour(01-12) |
PM | a | AM/PM |
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com