19 June 2018        Add to Favorites   Report

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 ! Create my free account now 🎁

Copied