Re: sysdate & date columns

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: Wed, 19 Jan 2000 21:03:13 -0500
Message-ID: <865qn9$ad4$1@bgtnsc01.worldnet.att.net>

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 - 20:03:13 CST