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: Date ... Date ...Da

Re: Date ... Date ...Da

From: <sybrandb_at_yahoo.com>
Date: 15 Apr 2004 00:45:24 -0700
Message-ID: <a1d154f4.0404142345.860243e@posting.google.com>


only_forme4_at_hotmail.com (moon) wrote in message news:<2afc1efd.0404141522.528bb030_at_posting.google.com>...
> Hi All,
>
> I don't know why Oracle complicating the issue of implicit and
> explicit converion, I think if they follow the same pattern of Java
> then it would be much better to deal with. Whatever, My question is
> about the following parg I read from Oracle SQL REf. and it says the
> following:
>
> "During arithmetic operations on and comparisons between character and
> noncharacter datatypes, Oracle converts from any character datatype to
> a
> number, date, or rowid, as appropriate. In arithmetic operations
> between
> CHAR/VARCHAR2 and NCHAR/NVARCHAR2, Oracle converts to a number."
>
> According to the Ref this should executes successfuly:
>
> >select '12-AUG-19' - sysdate from dual
>
> but i got this error:
>
> >ORA-00932: inconsistent datatypes: expected CHAR got DATE
>
> Why ? Why?
>
> Thank you very much for your help in advance
>
> Note:
> The NLS_DATE_FORMAT is 'DD-MON-RR'
>
> :)

1 Sound programming never ever relies on a default date format, which can be changed on the fly on session level 2 So just learn to live with it, and type those few extra characters.

Sybrand Bakker
Senior Oracle DBA Received on Thu Apr 15 2004 - 02:45:24 CDT

Original text of this message

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