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: Kevin Martin <brasscannon_at_bigfoot.com>
Date: 1998/11/14
Message-ID: <8D10.7BDCCE176Ebrscnnn@news.frontiernet.net>#1/1

"" dmurphy4086_at_my-dejanews.com wrote in <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[?]

Have you seen a parameter called "NLS_DATE_FORMAT"? I'm a bit new to this myself* but it sounds like what you're looking for.

-- 
Kevin Martin <brasscannon_at_bigfoot.com>
*(new to Oracle, that is! long history in other stuff)
Received on Sat Nov 14 1998 - 00:00:00 CST

Original text of this message

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