Re: to_char_at_timezone()?

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: to_char_at_timezone()?
Дата
Msg-id 545A6EF3.8010008@joh.to
обсуждение исходный текст
Ответ на Re: to_char_at_timezone()?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
On 11/5/14, 7:36 PM, Josh Berkus wrote:
> On 11/04/2014 04:04 PM, Marko Tiikkaja wrote:
>> In my example, the input is a "timestamptz", and the output is converted
>> to the target time zone the same way timestamptz_out() does, except
>> based on the input timezone instead of TimeZone.
>>
>> Not sure whether it would make sense to do this for "timestamp", or
>> whether there's even a clear intuitive behaviour there.
>
> Why wouldn't we just add the timezone as an additional parameter?

Are you suggesting that we add a new overload of to_char() instead of a 
new function to_char_at_timezone()?  That sounds a bit confusing, but 
that might just be me.


.marko



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: to_char_at_timezone()?
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: pg_multixact not getting truncated