Oracle Time Format (to_char,to_date)

select to_char(sysdate,'YYYY/MM/DD HH:MI:SS') FROM DUAL;

select count(column) from table t
where date >to_date('2007/09/01 01:01:01','YYYY/MM/DD HH24:MI:SS')