Re: To get the name of a weekday in other Language? - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: To get the name of a weekday in other Language?
Date
Msg-id 20140818103453.GA9836@tux
Whole thread Raw
In response to To get the name of a weekday in other Language?  (Csányi Pál <csanyipal@gmail.com>)
List pgsql-novice
Csányi Pál <csanyipal@gmail.com> wrote:

> Hi,
>
> can I get the name of a weekday in Hungarian?
>
> The command that I'm running is:
>
> select to_char(date '2014-08-19','Day');
>   to_char
> -----------
>  Tuesday
> (1 row)
>
> Can I get instead of Tuesday the weekday name in Hungarian ( which is Kedd )?

Use the TM-prefix, Translation Mode:

test=*# select to_char(date '2014-08-19','Day');
  to_char
-----------
 Tuesday
(1 row)

Time: 0,560 ms
test=*#
test=*#
test=*# select to_char(date '2014-08-19','TMDay');
 to_char
----------
 Dienstag
(1 row)


See:
http://www.postgresql.org/docs/current/interactive/functions-formatting.html
Table 9-22


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°


pgsql-novice by date:

Previous
From: Csányi Pál
Date:
Subject: To get the name of a weekday in other Language?
Next
From: Marc Richter
Date:
Subject: Re: Upgrading from PG 8.2.5 to 9.1.13