Re: Year 2000 problem
From: Bhaskar Gandavabi <bgandavabi_at_ix.netcom.com>
Date: 1998/03/25
Message-ID: <6fbrni$m4t_at_dfw-ixnews2.ix.netcom.com>#1/1
Date: 1998/03/25
Message-ID: <6fbrni$m4t_at_dfw-ixnews2.ix.netcom.com>#1/1
If you are using Oracle 7.3 version and up, it supports a format 'rr' for
'yy'.
'dd-mon-rr'
Did you try this.
What it does is: and year is translated as 19-- if the year is 50 or above
and 20-- if it is below 50
e.g.: 01-mar-10 is 01-Mar-2010
and 01-mar-90 is 01-Mar-1990.
Hope I was able to help you.
Anu.
Swaroop wrote in message
<01bd575a$cb3a2320$8b900714_at_bbowman.msc.isd.csc.com>...
>
>I wonder if somebody can help me with date conversion in Pro*C
>
>I'm converting the date to char using dd-mon-yyyy format. This takes long
>time
>to execute a pro*c program.
>
>
>If u have any alternatives pl. send a mail to swaroopk_at_hotmail.com
>
>
>
>
Received on Wed Mar 25 1998 - 00:00:00 CET