YYYYMMDDHHMIMISS is strange, it asks twice for the minutes
YYYYMMDDHH24MISS should work
Ong Chin Hui <chong_at_singaport.gov.sg> schreef in artikel
<34263b81.532531058_at_news.pacific.net.sg>...
> 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
