Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to get record of time for yesterday in the oracle table?
Hi
This will not work?
select f1
from t1
where trunc(f1)=trunc(sysdate-1);
rateng <rateng_at_wz.col.com.cn> wrote in message
news:808b2s$lhr$1_at_news.cz.js.cn...
> Hi any one,
>
> I has a samll question with this.
> I want to get record of time for yesterday in the table of oracle8.
> I don't know what is performing function filterring 'Select' condition
that
> is field of whattime is of yesterday. Can any one tell me with this ?
> think you .
>
> regard
>
> rateng
>
>
>
>
Received on Tue Nov 09 1999 - 05:22:18 CST