August 5, 2014

Timestamp format

select count(*) from table1 where last_updt_ts > cast('2014-01-01:00:00:00' as timestamp format 'yyyy-mm-dd:hh:mi:ss')

No comments:

Post a Comment