Re: Can you set the date output format (to_char style) per session?

Поиск
Список
Период
Сортировка
От Joshua Johnston
Тема Re: Can you set the date output format (to_char style) per session?
Дата
Msg-id A35EA0B1-0548-496C-A901-ABD377D8AF44@gmail.com
обсуждение исходный текст
Ответ на Re: Can you set the date output format (to_char style) per session?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
On Mar 4, 2010, at 2:51 PM, Pavel Stehule wrote:

> 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
>

That is what I thought. Thank you for your quick reply Pavel!

В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Can you set the date output format (to_char style) per session?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Optimal database table optimization method