Question

在select中怎么获取now()的date？

select * from 1 where time = ...

我想where能等于今天的日期.就是today(date)
怎么弄？

Answer 1

Oracle 里面
where to_char(time,'yyyy-mm-dd') = to_char(sysdate,'yyyy-mm-dd')

Answer 2

select * from 1 where trunc(time)=trunc(sysdate)