Re: date format

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/09/18
Message-ID: <3420ca16.333547@www.sigov.si>#1/1

On Wed, 17 Sep 1997 15:32:26 -0500, AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu> wrote:

>> Ong Chin Hui wrote:
>>
>> Be default, oracle returns a YYYYMMDDHHMM format for date fields. How
>> can I change the default format to something else, like YYYYMMDDHHMMSS
>
>ALTER SESSION SET NLS_DATE_FORMAT ='YYYYMMDDHHMMSS'
I know it's a typo but anyway: in date format strings minutes are represented by "MI", not by "MM" which represents month.

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Sep 18 1997 - 00:00:00 CDT