Re: date format

From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/09/17
Message-ID: <34203E5A.6504@charlie.cns.iit.edu>#1/1

Ong Chin Hui wrote:
>
> 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
> ?

ALTER SESSION SET NLS_DATE_FORMAT ='YYYYMMDDHHMMSS' HOPE THIS HELPS AMARENDRA

-- 
******************************************************************************
AMARENDRA B NETTEM			5039 N E River Road, Apt. 1A
Certified Oracle DBA			NORRIDGE, IL 60656
Whittman-Hart Inc., 
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.  

Ph.No. (708) 583 9870 (H)  
       (312) 913 6758 (W)  

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************************
Opinions are mine and do not necessarily reflect those of Whittman-hart
Inc.

Received on Wed Sep 17 1997 - 00:00:00 CDT