Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sysdate & date columns
Mohamed Buhari <mbuhari_at_assigncorp.com> wrote in message
news:38866A8F.B0A0C25F_at_assigncorp.com...
> Try This....
>
> alter session set NLS_DATE_FORMAT='MM-DD-YYYY'; --no time info
> select * from table1 where date1 = sysdate;
>
> This must work!
No.
NLS_DATE_FORMAT only affects the displaying output and accessing input of a date value, not the date value itself. Received on Sat Jan 22 2000 - 18:33:28 CST