°ÑSQLÓï¾äת»¯³Éoracle - Oracle / »ù´¡ºÍ¹ÜÀí

SQL£ºselect * from smfd_ForeighStockPoint where AddTime between '2010/5/26 8:30:05' and '2010/5/26 8:40:05'
oracleµÄÈÕÆÚ¸ñʽÊÇ¡®04-3Ô -10 10.32.04.460000 ÉÏÎ硯£¬ÇëÎÊÕâÑùÔõôд£¿£¿

---

to_dateº¯Êý

---

select * from smfd_ForeighStockPoint where AddTime between to_date('2010/5/26 8:30:05','yyyy/mm/dd HH24:mi:ss') and to_date('2010/5/26 8:40:05','yyyy/mm/dd HH24:mi:ss')

---

ÒýÓÃ

select * from smfd_ForeighStockPoint where AddTime between to_date('2010/5/26 8:30:05','yyyy/mm/dd HH24:mi:ss') and to_date('2010/5/26 8:40:05','yyyy/mm/dd HH24:mi:ss')

Õý½â£¡ÓÃto_date£¨£©×ª»»³ÉÈÕÆÚÐÍ

---

ʹÓÃto_date£¨£©º¯Êý£¬ÈÕÆÚ¸ñʽÏëÔõôÉèÖö¼ok

---

Â¥É϶¼ÊÇÕý½â