ALTER SESSION SET NLS_DATE_FORMAT

2001-03-15 Thread Wendy Y
Hello: Can anyone explain to me what exactly 'Alter Session' will do? Will it alter the session all the way until it close? How do I find out what kind of mode is my SQLPLUS session currently on? I have following script like: ALTER SESSION SET NLS_DATE_FORMAT = '-MM-DD-HH24.MI.SS';SELECT

RE: ALTER SESSION SET NLS_DATE_FORMAT

2001-03-15 Thread Jacques Kilchoer
Title: RE: ALTER SESSION SET NLS_DATE_FORMAT -Original Message- From: Wendy Y [mailto:[EMAIL PROTECTED]] Can anyone explain to me what exactly 'Alter Session' will do? Will it alter the session all the way until it close? How do I find out what kind of mode is my SQLPLUS session

Re: ALTER SESSION SET NLS_DATE_FORMAT

2001-03-15 Thread Ruth Gramolini
l it alter the session all the way until it close? How do I find out what kind of mode is my SQLPLUS session currently on? I have following script like: ALTER SESSION SET NLS_DATE_FORMAT = '-MM-DD-HH24.MI.SS'; SELECT ... FROM ... WHERE ... (TO_DATE(SUBSTR(KOMP.DATCRE,1,19),'-MM-DD-