Re: date format

From: Ong Chin Hui <chong_at_singaport.gov.sg>
Date: 1997/09/22
Message-ID: <34263b81.532531058@news.pacific.net.sg>#1/1

On Tue, 16 Sep 1997 03:41:12 GMT, chong_at_singaport.gov.sg (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
>?

A few replies pointing to setting NLS_DATE_FORMAT using YYYYMMDDHHMMSS but it doesn't seem to work as there is no way to differentiate between months and minutes. I tried the YYYYMMDDHHMIMISS but failed too. Any other suggestions ? Received on Mon Sep 22 1997 - 00:00:00 CDT