Re: Date Timezone

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Date Timezone
Дата
Msg-id dcc563d10711221330w79979c3by2c4608b92c49d791@mail.gmail.com
обсуждение исходный текст
Ответ на Date Timezone  ("Andrew Maclean" <andrew.amaclean@gmail.com>)
Список pgsql-general
On Nov 22, 2007 3:16 PM, Andrew Maclean <andrew.amaclean@gmail.com> wrote:
> I have a problem in that dates are stored as UTC in my dataase. I.e. without
> timezone.
>
> What I want to do: is to get this date from the server and add the server's
> current time zone to it. Then I will present a list of dates and times to
> the user in their time-zone.  How can I do this? I have been trying to get
> the timezone from now() and adding it but I can't see how.
>
> Of course this doesn't account for daylight saving.

Does this help?

http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Date Timezone
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Date Timezone