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: Possible Y2K trap in using DECODE?

Re: Possible Y2K trap in using DECODE?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 13 Jan 1999 17:10:04 +0800
Message-ID: <369C62EC.3E5@bhp.com.au>


Shawn Ramsey wrote:
>
> Snip
>
> >Like you said earlier, your problem comes from the implicit converts from
> date
> >to varchar (and vice versa) using the default date format. You could
> change
> >the default date format, but since it can be changed by each user and thus
> >override your system setting this wouldn't guarantee a solution (though it
> >could be acceptable). The other solution, which doesn't rely on a "magic"
> >value such as 'xyzab_-', is to make sure there are no implicit conversions:
>
> Why not just explicitly set the date format in the sql*plus session? Just
> do an ALTER SESSION SET NLS_DATE_FORMAT 'DDMMYYYY' then there will be no
> question on the conversion.

Easy in your SQL Plus session - not so easy if you have the same code in 500 or so application programs... :)

Cheers
--



Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad" Received on Wed Jan 13 1999 - 03:10:04 CST

Original text of this message

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