Question

在plsql中怎么以带时分秒的时间字段作为查询条件。

请写出具体的sql语句

Answer 1

带时分秒的时间字段是指Timestamp类型的字段么？可以用CAST(XXXtimestamp AS DATE)函数来转换为Date类型，也可以反向转换：CAST(XXXdate AS TIMESTAMP)

e.g.

SELECT CAST(SYSTIMESTAMP AS DATE) AS AAA FROM DUAL
AAA
------------------------
2013-4-22 14:26:56

SELECT CAST(SYSDATE AS TIMESTAMP) AS AAA FROM DUAL
AAA
------------------------
22-4月 -13 02.23.55.000000 下午

Answer 2

转换成时间格式可以么？ to_date(shijian,'yyyy/mm/dd hh24:mi:ss')