Postgres Pro
Downloads
Home   >   mailing lists

Re: Can you set the date output format (to_char style) per session? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Can you set the date output format (to_char style) per session?
Date
Msg-id 162867791003041151n64ab31edp19e30e31fb97522d@mail.gmail.com
Whole thread Raw
In response to Can you set the date output format (to_char style) per session?  (Joshua Johnston <johnston.joshua@gmail.com>)
Responses Re: Can you set the date output format (to_char style) per session?
List pgsql-general
Tree view 
hello

2010/3/4 Joshua Johnston <johnston.joshua@gmail.com>:
> Hello list!
>
> I am working through some i18n/l10n issues in a new application and one of our possible solutions for handling date
formattingis to have the dates formatted by pgsql per session. I know I Can use DateStyle to adjust date output, but I
amlooking for something that works like SET DateStyle but with finer control like to_char(format, timestamp). 
>
> Is there such thing?
>

no

no on sql level - you can do some only in C lang - create own type -
compatible with timestamp but with own output function.

regards
Pavel Stehule


> Thanks,
>
> Josh
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Joshua Johnston
Date:
Subject: Can you set the date output format (to_char style) per session?
Next
From: Joshua Johnston
Date:
Subject: Re: Can you set the date output format (to_char style) per session?