Alexander, Your example below is very helpful, and explains why I recalled that duplicating date elements was possible. I probably used TO_CHAR to test this in the past, while the other day I was using ALTER SESSION.
My theory on why you can't duplicate elements when setting NLS_DATE_FORMAT is that the NLS_DATE_FORMAT value gets used for both input AND output. It's no problem to spit the month out twice in two different ways, but there's probably some issues involved with making users specify the month twice. For example, what if a user specifies two different months, as in: Feb (03) 15, 2002? This is becomming clearer to me now. Thanks. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Monday, February 11, 2002, 10:48:20 PM, you wrote: AFmc> You can, using to_char, but not in "alter ... nls ..." SQL>> select to_char(sysdate,'Mon (MM) DD, YYYY') from dual; AFmc> TO_CHAR(SYSDATE,' AFmc> ----------------- AFmc> Feb (02) 11, 2002 AFmc> 1 row selected. AFmc> Alex. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
