SELECT * FROM TEST1 WHERE TO_CHAR(TIMESTAMP,'yyyy-MM-dd') > SUBSTR('2017-07-21 16:49:59',0,10)SELECT * FROM TEST1 WHERE TO_CHAR(TIMESTAMP,'yy
SELECT * FROM TEST1 WHERE TO_CHAR(TIMESTAMP,'yyyy-MM-dd') > SUBSTR('2017-07-21 16:49:59',0,10)SELECT * FROM TEST1 WHERE TO_CHAR(TIMESTAMP,'yy