Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date Formats in Oracle 8.x

Re: Date Formats in Oracle 8.x

From: José Nicolau <jnicolau_at_hotmail.com>
Date: 1998/11/22
Message-ID: <36583631.6C0C0621@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 CST

Original text of this message

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