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.