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: fumi <fumi_at_tpts5.seed.net.tw>
Date: 23 Jan 2000 00:33:28 GMT
Message-ID: <86di8o$alt$3@news.seed.net.tw>

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

Original text of this message

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