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) |
note
1. The am/pm names depend upon the locale setting in
Contract Express Administrator
.2. If you do not apply a format to a time value it will use the locale format which is "hh12:mm:ss" for both the english_uk and english_usa locales.
3. Time ingredients are case-sensitive, so ampm is different from AMPM.
4. If you want the letter "s" to be treated as static text, use "^s". This applies to all ingredients, so "^a^m^p^m" represents the static text "ampm".