Re: Date Formats in Oracle 8.x
From: Kevin Martin <brasscannon_at_bigfoot.com>
Date: 1998/11/14
Message-ID: <8D10.7BDCCE176Ebrscnnn_at_news.frontiernet.net>#1/1
Date: 1998/11/14
Message-ID: <8D10.7BDCCE176Ebrscnnn_at_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 CET