HOUR:
MINUTE:
SECOND:
TIME SEPARATOR:
A time literal has the following format.
{t 'HH[: | - | .]MM[: | - | .]SS' }
where HH is the one or two digit hour, in 24 hour format (0 to 23), MM is the one or two digit minute (0-59) and SS is the one or two digit seconds (0-59)
Time literals cannot specify a seconds value with a fractional component. Only the timestamp literal has a seconds value with a fractional component.
Time literals have a Time SQL type.
When a character literal is used in an expression that expects a time, CONNX will assume the supplied character string is a time literal, even without the time literal prefix '{t' and suffix '}'.
Examples of valid time literals:
|
Literal |
Validity |
|
{t '12:34:56' } |
valid |
|
{t '12-34-56' } |
valid |
|
{t '12.34.56' } |
valid |
|
{t '99:03:33' } |
invalid hour |
|
{t '00:99:00' } |
invalid minute |