The standard format for dates and times in FME is any of:
yyyymmdd
hhmmss[.x+][(+/-)zz]
yyyymmddhhmmss[.x+][(+/-)zz]
| Where | Description | Example |
|---|---|---|
| yyyy | year in 4 digits | 2011 |
| mm | month number | 07 (July) |
| dd | day of the month | 05 |
| hh | hour of a 24-hour clock | 14 (2:00 p.m.) |
| mm | number of minutes | |
| ss | number of seconds | |
| [.x+] | optional fraction of a second, represented by one or more digits | |
| [(+/-)zz] | optional timezone | compared to GMT, so -08 is Pacific Time Zone PST |
Example
The time 08:37:10, 8 Sep 2011 (PST) is:
20110908083710.000-08