1.select * from table1 where to_char(date1,'yyyy-mm-dd hh24:mi:ss')='2008-10-10 10:10:88';2.select * from table1 where to_char(date1,'yyyymmdd')=20081010;
用上下面的条件: to_char(列名,'yyyymmdd')='20081010'
同意楼上。 sysdate里面还有毫秒,微秒
1: WHERE TO_CHAR(DATE_COLUMN,'YYYYMMDD')='20081010' 2: WHERE TRUNC(DATE_COLUMN,'YYYYMMDD') = TRUNC(TO_DATE('20081010','YYYYMMDD'))
to_char(列名,'yyyymmdd')='20081010'
sysdate里面还有毫秒,微秒
2: WHERE TRUNC(DATE_COLUMN,'YYYYMMDD') = TRUNC(TO_DATE('20081010','YYYYMMDD'))