RE: Languages
- From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- To: <gamito@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Oct 2008 07:49:58 -0500
This seems to be a NLS environment issue. Try setting nls_date_format and/or
nls_language.
hth
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mário Gamito
Sent: Thursday, October 09, 2008 9:23 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Languages
Hi,
I've installed Oracle 10g in Windows, and it installed both English
and Portuguese languages.
All the software is English writen. The feedback, errors and warnings
are in portuguese. It's not to my liking, but I can live with that.
The problem is in the SQL itself.
For example, if I try to get the day after FRIday, I get an error with
this statement:
SELECT NEXT_DAY(SYSDATE, 'FRI') FROM dual;
because, FRI(day) is for English. The statement runs smoothly if I
change "FRI" for "SEX" which are the first three letters for Friday in
portuguse (sexta).
Does anyone knows how can I set the whole system to be in English ?
Any help would be appreciated.
Warm Regards,
Mário Gamito
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
