The following table lists the different formats used by UFI for date columns in UFI Template Setup.
|
Format Specifier |
Description |
Examples |
|---|---|---|
|
d |
The day of the month, from 1 through 31. |
6/1/2023 1:45:30 PM -> 1 6/15/2023 1:45:30 PM -> 15 |
|
Dd |
The day of the month, from 01 through 31. |
6/1/2023 1:45:30 PM -> 01 6/15/2023 1:45:30 PM -> 15 |
|
Ddd |
The abbreviated name of the day of the week. |
6/15/2023 1:45:30 PM -> Mon (en-US) 6/15/2023 1:45:30 PM -> Пн (ru-RU) 6/15/2023 1:45:30 PM -> lun. (fr-FR) |
|
Dddd |
The full name of the day of the week. |
6/15/2023 1:45:30 PM -> Monday (en-US) 6/15/2023 1:45:30 PM -> понедельник (ru-RU) 6/15/2023 1:45:30 PM -> lundi (fr-FR) |
|
h |
The hour, using a 12-hour clock from 1 to 12. |
6/15/2023 1:45:30 AM -> 1 6/15/2023 1:45:30 PM -> 1 |
|
Hh |
The hour, using a 12-hour clock from 01 to 12. |
6/15/2023 1:45:30 AM -> 01 6/15/2023 1:45:30 PM -> 01 |
|
H |
The hour, using a 24-hour clock from 0 to 23. |
6/15/2023 1:45:30 AM -> 1 6/15/2023 1:45:30 PM -> 13 |
|
HH |
The hour, using a 24-hour clock from 00 to 23. |
6/15/2023 1:45:30 AM -> 01 6/15/2023 1:45:30 PM -> 13 |
|
K |
Time zone information. |
With DateTime values: 6/15/2023 1:45:30 PM, Kind Unspecified -> 6/15/2023 1:45:30 PM, Kind Utc -> Z 6/15/2023 1:45:30 PM, Kind Local -> -07:00 (depends on local computer settings) With DateTimeOffset values: 6/15/2023 1:45:30 AM -07:00 --> -07:00 6/15/2023 8:45:30 AM +00:00 --> +00:00 |
|
M |
The minute, from 0 through 59. |
6/15/2023 1:09:30 AM -> 9 6/15/2023 1:09:30 PM -> 9 |
|
Mm |
The minute, from 00 through 59. |
6/15/2023 1:09:30 AM -> 09 6/15/2023 1:09:30 PM -> 09 |
|
M |
The month, from 1 through 12. |
6/15/2023 1:45:30 PM -> 6 |
|
MM |
The month, from 01 through 12 |
6/15/2023 1:45:30 PM -> 06 |
|
MMM |
The abbreviated name of the month. |
6/15/2023 1:45:30 PM -> Jun (en-US) 6/15/2023 1:45:30 PM -> juin (fr-FR) 6/15/2023 1:45:30 PM -> Jun (zu-ZA) |
|
MMMM |
The full name of the month. |
6/15/2023 1:45:30 PM -> June (en-US) 6/15/2023 1:45:30 PM -> juni (da-DK) |
|
s |
The second, from 0 through 59. |
6/15/2023 1:45:09 PM -> 9 |
|
Ss |
The second, from 00 through 59. |
6/15/2023 1:45:09 PM -> 09 |
|
t |
The first character of the AM/PM designator. |
6/15/2023 1:45:30 PM -> P (en-US) 6/15/2023 1:45:30 PM -> 午 (ja-JP) 6/15/2023 1:45:30 PM -> (fr-FR) |
|
tt |
The AM/PM designator. |
6/15/2023 1:45:30 PM -> PM (en-US) 6/15/2023 1:45:30 PM -> 午後 (ja-JP) 6/15/2023 1:45:30 PM -> (fr-FR) |
|
Y |
The year, from 0 to 99. |
1/1/0001 12:00:00 AM -> 1 1/1/0900 12:00:00 AM -> 0 1/1/1900 12:00:00 AM -> 0 6/15/2023 1:45:30 PM -> 9 |
|
Yy |
The year, from 00 to 99. |
1/1/0001 12:00:00 AM -> 01 1/1/0900 12:00:00 AM -> 00 1/1/1900 12:00:00 AM -> 00 6/15/2023 1:45:30 PM -> 09 |
|
Yyyy |
The year as a four-digit number. |
1/1/0001 12:00:00 AM -> 0001 1/1/0900 12:00:00 AM -> 0900 1/1/1900 12:00:00 AM -> 1900 6/15/2023 1:45:30 PM -> 2023 |
|
z |
Hours offset from UTC, with no leading zeros. |
6/15/2023 1:45:30 PM -07:00 -> -7 |
|
Zz |
Hours offset from UTC, with a leading zero for a single-digit value. |
6/15/2023 1:45:30 PM -07:00 -> -07 |
|
Zzz |
Hours and minutes offset from UTC. |
6/15/2023 1:45:30 PM -07:00 -> -07:00 |
|
: |
The time separator. |
6/15/2023 1:45:30 PM -> : (en-US) 6/15/2023 1:45:30 PM -> . (it-IT) 6/15/2023 1:45:30 PM -> : (ja-JP) |
|
/ |
The date separator. |
6/15/2023 1:45:30 PM -> / (en-US) 6/15/2023 1:45:30 PM -> - (ar-DZ) 6/15/2023 1:45:30 PM -> . (tr-TR) |
Want to Know More?
Visit the WebTMA Help Page