oracleÈçºÎ±È½Ïʱ¼ä£¿

1¡¢
select  t1.DEVICE_NAME ,t2.MONITOR_NAME,t3.OBJECTNAME,t3.SAMPLENAME,t3.SAMPLETIME  from T_DEVICE t1,T_MONITOR t2,T_SAMPLES t3 where t1.DEVICE_ID=t2.DEVICE_ID and t2.MONITOR_ID=t3.MONITOR_ID 
and  t3.SAMPLETIME <sysdate order by t1.DEVICE_NAME
2¡¢
select  t1.DEVICE_NAME ,t2.MONITOR_NAME,t3.OBJECTNAME,t3.SAMPLENAME,t3.SAMPLETIME  from T_DEVICE t1,T_MONITOR t2,T_SAMPLES t3 where t1.DEVICE_ID=t2.DEVICE_ID and t2.MONITOR_ID=t3.MONITOR_ID 
and  t3.SAMPLETIME <21-¾ÅÔ -2009 05:19:04 PM order by t1.DEVICE_NAME

1Óï¾äÖ´ÐÐûÎÊÌ⣬2Óï¾äÖ´ÐÐ˵ʲôË÷ÒýÖжªÊ§in»òout ²ÎÊý £¬  Çë¸÷λָµãһϣ¡ ¾¿¾¹ÒªÈçºÎÈ¥±È½Ïoracleʱ¼ä

---

21-¾ÅÔ -2009 05:19:04 PM
-->ת»»ÏÂ
to_date('21-¾ÅÔ -2009 05:19:04 PM','yyyy-mm-dd hh24:mi:ss')

---

21-¾ÅÔ -2009 05:19:04 PM
´¦ÀíΪ±ê׼ʱ¼ä¸ñʽ
'yyyy-mm-dd hh24:mi:ss'

---

ÒýÓÃ

1¡¢
select  t1.DEVICE_NAME ,t2.MONITOR_NAME,t3.OBJECTNAME,t3.SAMPLENAME,t3.SAMPLETIME  from T_DEVICE t1,T_MONITOR t2,T_SAMPLES t3 where t1.DEVICE_ID=t2.DEVICE_ID and t2.MONITOR_ID=t3.MONITOR_ID 
and  t3.SAMPLETIME <sysdateorder by t1.DEVICE_NAME
2¡¢
select  t1.DEVICE_NAME ,t2.MONITOR_NAME,t3.OBJECTNAME,t3.SAMPLENAME,t3.SAMPLETIME  from T_DEVICE t1,T_MONITOR t2,T_SAMPLES t3 where t1.DEVICE_ID=t2.DEVICE_ID and t2.MONITOR_ID=t3.MON