From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Date formatting function |
Date: | 2011-06-17 17:27:08 |
Message-ID: | 20110617172708.GA21979@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> wrote:
> I am using the following formatting function for a date field and I get the
> name of the month in English language. How can I get it in Spanish?
>
> to_char(sea_fecha,'MONTH DD, YYYY') as sea_fecha_aux
I think, you have to use the 'translation mode prefix', see
http://www.postgresql.org/docs/8.4/interactive/functions-formatting.html
Table 9-22. Template Pattern Modifiers for Date/Time Formatting
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | James David Smith | 2011-06-17 19:12:49 | Re: Extract from date field |
Previous Message | JORGE MALDONADO | 2011-06-17 17:17:53 | Date formatting function |