Date and time format examples
The following list includes examples of popular standard date and time formats:
- Format
- Description
- X12 EDI
Fractional seconds format:
HH24MM[SS[0-2]]
.- SWIFT
Time Zone Designator or UTC Designator format:
HH24MMSS[TZD]
.TimeStamp format:
CCYY-MM-DDTHH:MM[SS[.0-6]][TZD]
, which is a combination of date and time.- HL7
Time format:
HH24MM[SS[.0-6]][+/-ZZZZ]
.TimeStamp format:
CCYYMMDDHHMM[SS[.0-6]][+/-ZZZZ]
, which is a combination of date and time.- SAP
Time format:
HHMMSS
.- ODBC
Time format:
HH:MM:SS[.0-9]
, which is the form most commonly used in ODBC mapping. The fractional part is optional and not often used.