Re: date format

From: C. Mason <cmason_at_aai.arco.com>
Date: 1997/09/18
Message-ID: <01bcc47c$adf98150$ef6ae288@ato-10231>#1/1

Change the setting of the NLS_DATE_FORMAT parameter in your init.ora file.

NLS_DATE_FORMAT=YYYYMMDDHHMMSS Ong Chin Hui <chong_at_singaport.gov.sg> wrote in article <341dff92.3273676_at_news.pacific.net.sg>...
> I am using Oracle 7.3.2.
>
> Be default, oracle returns a YYYYMMDDHHMM format for date fields. How
> can I change the default format to something else, like YYYYMMDDHHMMSS
> ?
>
>
>
Received on Thu Sep 18 1997 - 00:00:00 CDT