Time units
Specifies the symbol and different units used to describe time.
- Symbol
- Description
- HH24
- Hour (based on a 24-hour clock) in two digits (00 to 24)
- H24
- Hour (based on a 24-hour clock) in one or two digits as needed (0 to 24)
- HH12
- Hour (based on a 12-hour clock) in two digits (1-12)
- H12
- Hour (based on a 12-hour clock) in one or two digits as needed (1 to 12)
- MM
- Minute in two digits (00 to 59)
- M
- Minute in one or two digits as needed (0 to 59)
- SS
- Seconds in two digits (00 to 59)
- S
- Second in one or two digits as needed (0 to 59)
- AM/PM
- Meridian (AM/PM)
- ZZZ
- Three character abbreviation for time zone (EST, and so on)
- +/-ZZZZ
- Hours and minutes before or after Greenwich Mean Time (GMT), also known as Coordinated Universal Time (UTC)
- +/-ZZ:ZZ
- 4-digit time where the format is a 2-digit hour and 2-digit minute, separated by a colon.
- +/-ZZ[:ZZ]
- 4-digit time where the format is a 2-digit hour and an optional 2-digit minute, separated by colon.
- +/-ZZ[ZZ]
- 4-digit time where the format is a 2-digit hour and an optional 2-digit minute.
- TZD
- 4-digit time where the format is a 2-digit hour and 2-digit minute, separated by a colon. Z on output, if value is +/-00:00.