POSTGRES - OBTENER FECHA HORA NUMERO DE DIA EN ESPAÑOL

CONSULTA:

select trim(case  when to_char(current_date,'d') = '1' then 'DOMINGO'
  when to_char(current_date,'d') = '2' then 'LUNES'
  when to_char(current_date,'d') = '3' then 'MARTES'
  when to_char(current_date,'d') = '4' then 'MIERCOLES'
  when to_char(current_date,'d') = '5' then 'JUEVES'
  when to_char(current_date,'d') = '6' then 'VIERNES'
  when to_char(current_date,'d') = '7' then 'SABADO'
 end)||' '|| to_char(current_date,'dd')||' '||trim(case when
to_char(current_date,'mm') = '01' then 'ENERO'
  when to_char(current_date,'mm') = '02' then 'FEBRERO'
  when to_char(current_date,'mm') = '03' then 'MARZO'
  when to_char(current_date,'mm') = '04' then 'ABRIL'
  when to_char(current_date,'mm') = '05' then 'MAYO'
  when to_char(current_date,'mm') = '06' then 'JUNIO'
  when to_char(current_date,'mm') = '07' then 'JULI0'
  when to_char(current_date,'mm') = '08' then 'AGOSTO'
  when to_char(current_date,'mm') = '09' then 'SETIEMBRE'
  when to_char(current_date,'mm') = '10' then 'OCTUBRE'
  when to_char(current_date,'mm') = '11' then 'NOVIEMBRE'
  when to_char(current_date,'mm') = '12' then 'DICIEMBRE'
 end)||' DEL '||trim(to_char(current_date,'yyyy'))


--------------------------------------------------------------------------------------------------------------

Postorigen: http://www.postgresql.org/message-id/d34a12b60601181548m119fc1cfw953f7fc58dc795ce@mail.gmail.com