Passing Timestamp in where clause in Teradata
There's only one recommended way to write a TIMESTAMP, using a Standard SQL literal, the keyword
TIMESTAMP' followed by a string with
'YYYY-MM-DD HH:MI:SS' format:
Where SCAN_TIME > TIMESTAMP '2015-01-01 13:11:00'
Similar literals exist for date & time:
DATE '2015-01-01' TIME '13:11:00'
Read great educational content like this and a lot more !
Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too