Timestamp Literal

YEAR:

MONTH:

DAY:

DATE SEPARATOR:

HOUR:

MINUTE:

SECOND:

TIME SEPARATOR:

A timestamp literal has the format:

 
{ts 'YYYY[- | / 
 | .]MM[- | / | .]DD[ | - | . | /]HH[: | - | .]MM[: | - | .]SS[- | / | 
 .FFFFFFFFF]' }

where :

YYYY is the four digit year
MM is the one or two digit month of the year (between 1 and 12)
DD is the one or two digit day of the month (between 1 and 31)
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), SS is the one or two digit seconds (0-59)
FFFFFFFFF is the zero to 10 digit fractional component of the seconds

Timestamp literals have a Timestamp SQL type.
When a character literal is used in an expression that expects a timestamp, CONNX will assume the supplied character string is a timestamp literal, even without the timestamp literal prefix '{ts' and suffix '}'.

Examples of valid timestamp literals: