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.
