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.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.