Re: how to change date format to include time?

From: <hongs_at_lge.co.kr>
Date: 1997/07/29
Message-ID: <870225646.1519@dejanews.com>#1/1

In article <5rkgu7$7cu$1_at_nntp.Stanford.EDU>,   afliu_at_leland.Stanford.EDU (Annabel Fang Liu) wrote:
>
>
> Hi,
>
> I am trying to change the date format in oracle 7.3.2 to include
> hour and minute. I would like to change the date format to be
> something like '199901012259'. Can anyone help me?
>
> Thanks.
>
> -Annabel
>
> --

set the NLS_DATE_FORMAT parameter to "YYYYMMDDHH24SS". You can set this param in initSID.ora file or use ALTER DATABASE SET ...command. Note that ALTER..command only applies for that session.

---

Sungsook Hong
Oracle DBA
LG Electronics Inc.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Tue Jul 29 1997 - 00:00:00 CDT