SELECT * FROM T_ZB_LIST WHERE to_char(ZB_TIME ,yyyy-mm-dd)< '2005/4/30' 试一下
SELECT * FROM T_ZB_LIST WHERE ZB_TIME between to_date('2005/4/30','yyyy/mm/dd') and to_date('2005/5/30','yyyy/mm/dd')
SELECT * FROM T_ZB_LIST WHERE ZB_TIME < '2005-4-30' 看看日期分隔符对不对
SELECT * FROM T_ZB_LIST WHERE ZB_TIME between to_date('2005/4/30','yyyy/mm/dd') and to_date('2005/5/30','yyyy/mm/dd') 才是正确的, lizhaogui() 和 : tanqth(青蛙) 都是在进行字符串比较,不是日期比较。
SELECT * FROM T_ZB_LIST WHERE trunc(ZB_TIME) between to_date('2005/4/30','yyyy/mm/dd') and to_date('2005/5/30','yyyy/mm/dd')加个函数trunc()表示只取日期部分。
两种写法: SELECT * FROM T_ZB_LIST WHERE TO_CHAR(ZB_TIME,'YYYY/MM/DD') < '2005/4/30'; SELECT * FROM T_ZB_LIST WHERE ZB_TIME < TO_DATE('2005/4/30','YYYYMMDD'); 不过,第一种应该会快点
不想转换成字符串:(ZB_TIME=2005/04/07) SELECT * FROM T_ZB_LIST WHERE substr(ZB_TIME,1,4)|| substr(ZB_TIME,6,2)|| substr(ZB_TIME,9,2) < '20050430'
试一下
看看日期分隔符对不对
才是正确的, lizhaogui() 和 : tanqth(青蛙) 都是在进行字符串比较,不是日期比较。
SELECT * FROM T_ZB_LIST WHERE TO_CHAR(ZB_TIME,'YYYY/MM/DD') < '2005/4/30';
SELECT * FROM T_ZB_LIST WHERE ZB_TIME < TO_DATE('2005/4/30','YYYYMMDD');
不过,第一种应该会快点
SELECT * FROM T_ZB_LIST
WHERE substr(ZB_TIME,1,4)|| substr(ZB_TIME,6,2)|| substr(ZB_TIME,9,2) < '20050430'