Error depending on date

[Sanderson]

Someone can help me and say what is wrong with the following code:

Select all

function CF_DATA_EXTENSOFormula return Char is 
  mês_extenso varchar(50); 
begin 
  RETURN  ( 'Porto Velho, '||TO_CHAR(SYSDATE,'DD')||' de '||INITCAP(LOWER(mês_EXTENSO(TO_CHAR(SYSDATE,'MM'))))||' de '||TO_CHAR(SYSDATE,'YYYY')); 
end;

Thanks

[dr_gori]

Well, as I do not have the mês_extensum function, I could not test here. But look: it's a lot easier to use the to_char to leave it extensive!

Select all

SQL> SELECT TO_CHAR( SYSDATE , 'Month' , 'NLS_DATE_LANGUAGE=PORTUGUESE' ) 
  2  FROM DUAL 
  3  / 
 
TO_CHAR(S 
--------- 
Outubro 
 
SQL> 

No need of INITCAP. Read this topic for you to find out more about the dates: http://en.glufke.net/oracle/viewtopic.php?t=22

[Sanderson]

Really using the toar was much better.

Thanks

[adrianoturbo]

I was doing a select to bring right by extensive the date with the to_char function (a hand on the wheel), good I just did.
Follow the train running for people test:

Select all

SELECT TO_CHAR(DT_NASC,'"Brasília" DD "de" Month" de "YYYY','NLS_DATE_LANGUAGE=PORTUGUESE' ) 
 FROM CLIENTE