TO_DATE

SELECT * FROM hoge WHERE date_val>TO_DATE('2007-06-01 14:14:59','yyyy-mm-dd hh24:mi:ss');