Data Integration Connectors
- Data Integration Connectors
- All Products
Date or Time Component
| Value Representation
| Date Pattern Terminology
|
---|---|---|
ERA Designator
| Text
| G
For example, If you want to specify the era as 20 AD, you can specify the value in GG:AD format, such as 20:AD.
|
Year
| Number
| y
For example, if you want to mention year as 2001, you can specify the value in yyyy:2001 or yy:01 format.
|
Month in year
| Number
| M
For example, if you want to mention year as June, you can specify the value in MMMM:JUNE or MM:06 or MMM:JUN format.
|
Week in year
| Number
| w
For example, if you want to specify the value as 45, you can specify the value in ww:45 format.
|
Week in month
| Number
| W
For example, if you want to specify the value as 2, you can specify the value in W:2 format.
|
Day in year
| Number
| D
For example, if you want to specify the value as 227, you can specify the value in DDD:227 format.
|
Day in a month
| Number
| d
For example, if you want to specify the value as 9, you can specify the value in dd:09 format.
|
Day of week in month
| Number
| F
For example, if you want to specify the value as 3, you can specify the value in F:3 format.
|
Day in week
| Text
| E
For example, if you want to specify the value as wednesday, you can specify the value in E:Wednesday format.
|
AM/PM marker
| Text
| a
For example, you can specify the value in aa:AM/PM format.
|
Hour in day (0-23)
| Number
| H
For example, if you want to specify the value as 15, you can specify the value in HH:15 format.
|
Hour in day (1-24)
| Number
| k
For example, if you want to specify the value as 24, you can specify the value in kk:24 format.
|
Hour in am/pm (0-11)
| Number
| K
For example, if you want to specify the value as 8, you can specify the value in K:8 format.
|
Hour in am/pm (1-12)
| Number
| h
For example, if you want to specify the value as 12, you can specify the value in hh:12 format.
|
Minute in hour
| Number
| m
For example, if you want to specify the value as 45, you can specify the value in mm:45 format.
|
Second in Minute
| Number
| s
For example, if you want to specify the value as 58, you can specify the value in ss:58 format.
|
Millisecond
| Number
| S
For example, if you want to specify the value as 450, you can specify the value in sss:450 format.
|
Time Zone
| General Time Zone
| z
For example, if you want to specify the value as 450, you can specify the value in sss:450 format.
|
Time Zone
| RFC 822 Time
| Z
For example, if you want to specify the value as 800, you can specify the value in zzz:800 format.
|