Re: Date Formats in Oracle 8.x

Hi David,

    Look into the use of the to_char function to convert your dates:

        to_char(col_name, 'MM-DD-YY') should give you the format you are after.

Jerry

dmurphy4086_at_my-dejanews.com wrote in message <72id7e$6g$1_at_nnrp1.dejanews.com>...
>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 Mon Nov 16 1998 - 00:00:00 CET