TIMESTAMP

Returns a timestamp from a value or a pair of values.

If only one argument is specified, it must be a timestamp, a valid string representation of a timestamp, or a character string of length 14. If two arguments are specified, the first argument must be a date or a valid string representation of a date. The second argument must be a time or a valid string representation of a time.

Example:

Assume the column START_DATE (date) has a value equivalent to 1988-12-25, and the column START_TIME (time) has a value equivalent to 17.12.30.

       TIMESTAMP(START_DATE, START_TIME)

Returns the value '1988-12-25-17.12.30.000000'.