Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sysdate & date columns

Re: sysdate & date columns

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 20 Jan 2000 13:35:33 +0100
Message-ID: <866veq$qc6$1@news5.isdnet.net>


Maybe:
select * from table1 where trunc(date1) = trunc(sysdate)

--
Have a nice day
Michel

Larry Pettit <larry.pettit_at_ps.net> a écrit dans le message : 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 Thu Jan 20 2000 - 06:35:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US