Select * From Table1 Where
Date1>to_date('yyyymmdd hh24miss','20040701 00:00:00') and
Date1<to_date('yyyymmdd hh24miss','20040801 00:00:00');
Date1>to_date('yyyymmdd hh24miss','20040701 00:00:00') and
Date1<to_date('yyyymmdd hh24miss','20040801 00:00:00');
Select * From Table1 Where
extract(year from date1)=2004 and extract(month from date1)=7
SELECT * FROM TABLE1
WHERE TO_CHAR(DATE1,'YYYYMM')='200407'
我试过可以的。
但是这样最好建立索引,关于TO_CHAR(DATE1,'YYYYMM')
Select * From Table1
Where Substr(tochar(Table1.Date1,'yyyy/mm/dd HH24:mi:s'),1,6) = '2004/07'
版主的substr用法没有错!只是要先进行日期转换!
select * from table where substr(to_char(table1.date,'yyyymmdd'),1,6)='200407'
要将日期限定在7月份,可以用
trunc(Date1) <=to_date('31/07/2004','dd/mm/yyyy')
AND
trunc(Date1) >=to_date('01/07/2004','dd/mm/yyyy')