Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » change language in date formta
change language in date formta [message #132290] Thu, 11 August 2005 14:12 Go to next message
carlos28
Messages: 3
Registered: July 2005
Junior Member
hi! anyone know how change the language date format.. like this in php

setlocale("LC_ALL","es_ES");

by defautl the date is english but i need in spanish (10-ene-2005)

and i dont want validate to transform jan by ene

tnanks!
Re: change language in date formta [message #134770 is a reply to message #132290] Fri, 26 August 2005 15:28 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Is the date extracted as a string from Oracle - or does to come back as a date type?

SQL> select to_char(sysdate, 'dd Month yyyy') from dual;

TO_CHAR(SYSDATE,'DDMONTHYYYY')
--------------------------------------------
26 August    2005

SQL> alter session set nls_language = spanish;

Session altered.

SQL> --begin execute immediate 'alter session set nls_language = spanish'; end;
SQL> --/
SQL> select to_char(sysdate, 'dd Month yyyy') from dual;

TO_CHAR(SYSDATE,'DDMONTHYYYY')
------------------------------------------------
26 Agosto     2005
Previous Topic: Tomcat, Oracle 9i and Chinese Characters
Next Topic: INFINITE WAITs WHEN PL/SQL FILTER USED WHILE OPENNING AN APPLICATION SERVER REPORT !!!
Goto Forum:
  


Current Time: Fri Nov 27 23:47:45 CST 2020