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.