Time Format

In the field:
{
expression
Format
format
}
where expression is a time value, the
format
is interpreted as a list of ingredients where each ingredient either specifies a component value (hour, minute, second, ampm) or is treated as a static character that will always appear.
For example, in the format text:
"hh24:mm:ss"
the ingredients are:
Ingredient
Description
hh24
hour component (00-23)
:
static character
mm
minute component (01-12)
:
static character
ss
second component

Time ingredients

The full list of ingredients for a time format:
Ingredient
Component
Description
hh24
24-hour
formatted as 2 digits (00-23)
h24
24-hour
formatted as 1 or 2 digits (0-23)
hh12
12-hour
formatted as 2 digits (01-12)
h12
12-hour
formatted as 1 or 2 digits (1-12)
ampm
12-hour
am/pm
AMPM
12-hour
midnight/a.m./midday/p.m.
mm
minute
formatted as 2 digits (00-59)
m
minute
formatted as 1 or 2 digits (0-59)
ss
second
formatted as 2 digits (00-59)
s
second
formatted as 1 or 2 digits (0-59)