Re: Date Formats in Oracle 8.x
From: (wrong string) é Nicolau <jnicolau_at_hotmail.com>
Date: 1998/11/22
Message-ID: <36583631.6C0C0621_at_hotmail.com>#1/1
Date: 1998/11/22
Message-ID: <36583631.6C0C0621_at_hotmail.com>#1/1
try
to_date(your_col_char_with_date, 'MM-DD-RR')
dmurphy4086_at_my-dejanews.com wrote:
> Hi - we are porting an app from DB2/400 to Oracle. When binding dates to
> strings in the code dates come back mm-dd-yy. Is there a way in Oracle to
> tell the DB to return dates in the same format so that we can avoid changing
> code. The default in oracle appears to be the entire timestamp which overfows
> our GUI fields.
>
> Thx
> David Murphy
> Columbine-JDS
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun Nov 22 1998 - 00:00:00 CET