把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

---

楼上都是正解