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:

\n\n
Where SCAN_TIME > TIMESTAMP '2015-01-01 13:11:00'\n
\n\n

Similar literals exist for date & time:

\n\n
DATE '2015-01-01'\nTIME '13:11:00'\n

dan-irving

posted on

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds