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.