110,539
社区成员
发帖
与我相关
我的任务
分享
select count(*) from LGBBS_USERARITICLE where DATATIME = trunc(sysdate)
select count(*) from LGBBS_USERARITICLE where to_date(DATATIME,'yyyy-mm-dd') = trunc(sysdate)
select * from table-name where updatetime >= to_date(to_char(sysdate,'yyyyMMdd'),'yyyyMMdd') and updatetime < to_date(to_char(sysdate+1,'yyyyMMdd'),'yyyyMMdd');
to_date('2009-06-18','yyyy-mm-dd')