select a, b from testtablewhere timestamp > to_date('20060530','yyyymmdd')
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') as LAST_MOD_DATE from dual