◆◆如何写这条查询语句◆◆

[haisha]

我想在表GZXB中查询时间大于'2003-03-12 10:00:00'的记录,提示有错,老提示有错,请高手帮我!

SELECT * FROM GZXB WHERE SLSJ > TO_DATE('2003-03-12 10:00:00','YYYY-MM-DD HH:MM:SS');

我用oracle 8.0.5

[haisha]

SLSJ 为日期型(date)

[pianer]

MM 改为MI

SELECT * FROM GZXB WHERE SLSJ > TO_DATE('2003-03-12 10:00:00','YYYY-MI-DD HH:MM:SS');

[HeavenHe]

应该是yyyy-mm-dd-hh:mi:ss

[beckhambobo]

SELECT * FROM GZXB WHERE SLSJ > TO_DATE('2003-03-12 10:00:00','YYYY-MM-DD HH24:Mi:SS');