oracle日期時間範圍查詢

標籤：logs   code   where   create   類型   data   href   bsp   tar   

Oracle的日期時間範圍查詢

欄位為：字串類型（char），長度為:10

SELECT * FROM testdatetime t WHERE 1=1 AND t.createdate >= ‘2011-06-01‘ AND t.createdate <= ‘2011-07-05‘;

SELECT * FROM testdatetime t WHERE 1=1 AND to_date(t.createdate,‘yyyy-MM-dd‘) 
between to_date(‘2011-06-01‘,‘yyyy-MM-dd‘) and to_date(‘20110705‘,‘yyyymmdd‘) ; 

欄位為：字串類型（char），長度為:20 

SELECT * FROM testdatetime t WHERE 1=1 AND t.usedate >= ‘2011-06-01‘ AND t.usedate <= ‘2011-07-05‘;    SELECT * FROM testdatetime t WHERE 1=1 AND to_date(t.usedate,‘yyyy-MM-dd HH24:MI:SS‘)between to_date(‘2011-07-01 12:00:00‘,‘yyyy-MM-dd HH24:MI:SS‘) and to_date(‘20110702 12:00:00‘,‘yyyymmdd HH24:MI:SS‘) ;  

欄位為：日期時間類型（date）

SELECT * FROM testdatetime t WHERE 1=1 AND t.startdate >= to_date(‘2011-07-01‘,‘yyyy-MM-dd‘) AND t.startdate <= to_date(‘2011-07-02‘,‘yyyy-MM-dd‘);  SELECT * FROM testdatetime t WHERE 1=1 AND t.startdate between to_date(‘2011-07-01‘,‘yyyy-MM-dd‘) AND to_date(‘2011-07-02‘,‘yyyy-MM-dd‘); 
SELECT * FROM testdatetime t WHERE 1=1 AND t.startdate = to_date(‘2011-07-01 12:00:00‘,‘yyyy-MM-dd HH24:MI:SS‘); 
SELECT * FROM testdatetime t WHERE 1=1 AND to_char(t.startdate,‘yyyy-MM-dd‘) = ‘2011-07-01‘;
SELECT * FROM testdatetime t WHERE 1=1 AND to_char(t.startdate,‘yyyy-MM-dd‘) >= ‘2011-07-01‘ AND to_char(t.startdate,‘yyyy-MM-dd‘) <= ‘2011-07-02‘;  

 

oracle日期時間範圍查詢