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