Re: Date Formats in Oracle 8.x

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: 1998/11/16
Message-ID: <72prfd$abv$1@client2.news.psi.net>#1/1

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 CST