timestamp

Returns a timestamp from a value or a pair of values. "Expression1" must represent a date value, and "expression2" must represent a time value.

Syntax

timestamp ( expression1 [ , expression2 ] )

timestamp ( 11 November 2005 , 12:00:00.000000 )

Result

Returns 2005-11-11-12:00:00.000000.