Date Formatting¶
There is no specific enforced date format that must be used. Mappings provide two attributes DateFormatFrom and DateFormatTo. Syntax for those attributes provided in the table below. A wide range of symbols is supported.
Syntax¶
| Format Character | Description | Example |
|---|---|---|
| Day | ||
| d and j | Day of the month, 2 digits with or without leading zeros | 01 to 31 or 1 to 31 |
| D and l | A textual representation of a day | Mon through Sun or Sunday through Saturday |
| S | English ordinal suffix for the day of the month, 2 characters. It’s ignored while processing. | st, nd, rd or th. |
| z | The day of the year (starting from 0) | 0 through 365 |
| Month | ||
| F and M | A textual representation of a month, such as January or Sept | January through December or Jan through Dec |
| m and n | Numeric representation of a month, with or without leading zeros | 01 through 12 or 1 through 12 |
| Year | ||
| Y | A full numeric representation of a year, 4 digits | 1999 or 2003 |
| y | A two digit representation of a year (which is assumed to be in the range 1970-2069, inclusive) | 99 or 03 (which will be interpreted as 1999 and 2003, respectively) |
| Time | ||
| a and A | Ante meridiem and Post meridiem | am or pm |
| g and h | 12-hour format of an hour with or without leading zero | 1 through 12 or 01 through 12 |
| G and H | 24-hour format of an hour with or without leading zeros | 0 through 23 or 00 through 23 |
| i | Minutes with leading zeros | 00 to 59 |
| s | Seconds, with leading zeros | 00 through 59 |
| u | Microseconds (up to six digits) | 45, 654321 |
| Timezone | ||
| e, O, P and T | Timezone identifier, or difference to UTC in hours, or difference to UTC with colon between hours and minutes, or timezone abbreviation | UTC, GMT, Atlantic/Azores or+0200 or +02:00 or EST, MDT |
| Full Date/Time | ||
| U | Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT) | 1292177455 |
| Whitespace and Separators | ||
| (space) | One space or one tab | |
| # | One of the following separation symbols: ; : / . , - ( ) | / |
| ; : / . , - ( ) | The specified character. | - |