TIMESTAMP

The TIMESTAMP function converts a date or a date + time into a time stamp.

Syntax

TIMESTAMP (date_string, [time_string]) 

Remarks

•

The date_string must be a STRING, DATE, or DATETIME data type.

•

The time_string must be a TIME data type and must not contain any DATE elements such as year, month, or day of month.

Example

TIMESTAMP ('AUG 11, 2014')

This results in a TIMESTAMP value of 2014-08-11 00:00:00.

TIMESTAMP ('AUG 11, 2014', '23:59:31')

This results in a TIMESTAMP value of 2014-08-11 23:59:31.