Re: date format

From: Thomas Vanya <twvanya_at_eastman.com>
Date: 1997/09/16
Message-ID: <01bcc2b2$b7c15800$0cdb74a6@pc88511209.tex.emn.com>#1/1

Try setting the initialization parameter NLS_DATE_FORMAT to your desired string.

-- 
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company

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 Tue Sep 16 1997 - 00:00:00 CDT