TIMESTAMP(a,b)

TIMESTAMP(a,b) is a function (extraction) that calculates from the expressions a and b a time stamp value comprising a date value, time value, and 0 microseconds.

Result of TIMESTAMP(a,b) Function

TIMESTAMP(a)

a must be a time stamp value or an alphanumeric value that matches the current time stamp format

The result is this time stamp value.

TIMESTAMP(a,b)

a must be a date value and b a time value (or alphanumeric value that matches the current format for date and time values).

The result is a time stamp value calculated from a date value, time value, and 0 microseconds.

a or b is the NULL value

NULL Value