Re: sysdate & date columns

Yes,
try trunc(date_column) = trunc(sysdate)

I do this all the time it takes the time portion off the date and compares just the date .

Buck Turgidson wrote:
>
> You're right, it most likely is the time node. Other than to_char, you can
> look at trunc, but that won't buy you much.
>
> Maybe try 'max(date) <= sysdate' type logic.
>
> Larry Pettit <larry.pettit_at_ps.net> wrote in message
> news:YTrh4.134$j4.7687_at_news.uswest.net...
> >
> > This doesn't work.
> >
> > select * from table1 where date1 = sysdate
> > Is there a way to compare a date column with sysdate other than
> > converting both using to_char()?
> >
> > I think the time part of the date is causing this not to work, any
> > suggestions?
> >
> > Thanks
> >
> >
Received on Wed Jan 19 2000 - 21:10:33 CST