Oracle 7.1.3.2 on VAX/VMS
SQL>
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'Mon (MM) DD, ';
ERROR:
ORA-01816: month may only be specified once
- Kirti
-Original Message-
Sent: Monday, February 11, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L
Would any of you who have conven
Hi Jonathan,
I only have 9i and 8.1.7 and in both cases I get the error
ora-01816: month may only be specified once.
John
[EMAIL PROTECTED] wrote:
>Would any of you who have convenient access to pre-9i
>databases be willing to test something for me? It used to be
>possible to specify a date fo
Can't do it in 8i:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'Mon (MM) DD, ';
ERROR:
ORA-01816: month may only be specified once
--- Jon
Title: RE: Date format element rule change
8.1.7.2.0 64bit HP-UX 11.0
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'Mon (MM) DD, ';
ERROR:
ORA-01816: month may only be specified once
Alex.
-Original Message-
From: Jonathan Gennick [mailto:[EMAIL PROTECTED]]
Sent: Mon
Doesn't work in 8i. (8.1.6 to be specific).
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'Mon (MM) DD, ';
ERROR:
ORA-01816: month may only be specified once
Marc Perkowitz
Senior Consultant
TWJ Consulting, LLP
847-256-8866 x15
www.twjconsulting.com
- Original Message -
To: "Multiple r
