Re: Altering session

From: m.mueller <m.mueller_at_snafu.de>
Date: Mon, 16 Jul 2001 13:30:20 +0200
Message-ID: <3B52D04C.8A09B447@snafu.de>

Hello Alain,
when you execute command ALTER SESSION... your date format is changed for the duration of SQL*Plus sesssion.
As far as I know it is not not stored. You can check out the format by SELECT SYSDATE ... before and after altering your SQL*Plus session.

"Default" format of date, checked before:
SQL> select sysdate from dual;

SYSDATE

---

16-JUL-01 SQL> alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';

Session altered.

"New" format of date:

SQL> select sysdate from dual;

SYSDATE

---

2001-07-16 13:17:23

Hope that helps
Manuela Mueller Received on Mon Jul 16 2001 - 06:30:20 CDT