Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: strange behaviour using to_char to return daynumber

Re: strange behaviour using to_char to return daynumber

From: <sybrandb_at_yahoo.com>
Date: 24 Apr 2006 06:00:40 -0700
Message-ID: <1145883640.808853.66970@e56g2000cwe.googlegroups.com>


Could well be a different NLS_TERRITORY or NLS_DATE_FORMAT setting on client and server. One side conforms to the ANSI definition and the other side conforms to the ISO definition. When not set, the settings on Windoze depend on the territory settings in the control panel. Also connecting from a higher version client to a lower version database isn't exactly downwards compatibility and may result in unknown problems, especially as 8.1.7.3 is desupported.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Mon Apr 24 2006 - 08:00:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US