Re: SYSDate, NLS_DATE_FORMAT, and default values

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com>
Date: 2000/05/07
Message-ID: <3915f5a4.3104546@news.alt.net>#1/1

On 06 May 2000 01:05:56 GMT, timkarnold_at_aol.com (TimKArnold) wrote:

>Are you on 8i?
>You may need to have DBA role.
>

OK, I logged on as SYS AS DBA via the SQL*Plus WorkSheet on NT.

And ran

---

CREATE OR REPLACE TRIGGER Data_Logon_Trigger AFTER LOGON
ON DATABASE
BEGIN
    EXECUTE IMMEDIATE
        'ALTER SESSION SET NLS_DATE_FORMAT = ''DD-MON-YYYY HH24:MI:SS''';
END;

---

I logged on again the same way.

I ran

SELECT SYSDate FROM Dual;

It returned

SYSDATE

---

07-MAY-00 Brian Received on Sun May 07 2000 - 00:00:00 CDT