oracle数据库，根据date类型查询，应该怎么格式化

Question

SELECT * FROM EAPUSER.SDB_TB_PRMS_EQP_RESIST
WHERE TIMESTAMP = To_Date('30-4月 -08','dd-mm-yy') ;

我这么写有什么问题么。

Answer 1

SELECT * FROM EAPUSER.SDB_TB_PRMS_EQP_RESIST
WHERE TIMESTAMP = To_Date('30-apr -08','dd-mon-yy') ;

SELECT * FROM EAPUSER.SDB_TB_PRMS_EQP_RESIST
WHERE TIMESTAMP = To_Date('30-4月 -08','dd-mm"月"-yy') ;