17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM TABLE WHERE A LIKE DATE '2012-02-01';
select * from table where A=To_Date('2012-02-01','YYYY-MM-DD');
select * from tb1 where to_char(A,'yyyy-mm-dd')='2012-02-01'
select * from table where to_char(a,'yyyymmdd') = '20120201';
select * from table where a=to_date('2012-02-01','yyyy-mm-dd')
select * from table where to_char(A,'YYYY-MM-DD')='2012-02-01'