我想求俩个时间之间的信息,用BETWEEN..AND.. 语句可以用吗? SELECT * FROM ECC_BJ.ECC_ACCOUNT WHERE CREATED_DATE BETWEEN '2001-01-01' AND '2001-02-01'
提示说: 文字与格式符串不匹配,这怎么改呢,对于时间的写法上?有什么时间函数可以求呢?谢谢
提示说: 文字与格式符串不匹配,这怎么改呢,对于时间的写法上?有什么时间函数可以求呢?谢谢
调试欢乐多
WHERE CREATED_DATE >='2001-01-01' AND
CREATED_DATE<= '2001-02-01'
如果是的话,这么些没有问题。
如果是access将'改为#
WHERE CREATED_DATE >='2001-01-01' AND
CREATED_DATE<= '2001-02-01'这样运行还是不对啊,为什么
WHERE to_char(CREATED_DATE,'yyyy-mm-dd' >='2001-01-01' AND
to_char(CREATED_DATE,'yyyy-mm-dd')<= '2001-02-01'
select * from table
where to_char(created_date,'yyyy-mm-dd') between '2001-01-01' AND '2001-02-01'
where hire_date between '1985-8-30' AND '1992-8-27'