Re: timezone() with timeofday() converts the wrong direction?

Поиск
Список
Период
Сортировка
От Steve - DND
Тема Re: timezone() with timeofday() converts the wrong direction?
Дата
Msg-id LDEHKBBOEMIJKHKBOFNFEEGONGAA.postgres@digitalnothing.com
обсуждение исходный текст
Ответ на Re: timezone() with timeofday() converts the wrong direction?  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: timezone() with timeofday() converts the wrong direction?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
>
> Perhaps this is what you want:
>
>   SELECT timezone('UTC', timeofday()::timestamptz);

That did it. Strangely, I thought I had tried that already, but I must not
have. My next question would be if I did:

    SELECT timezone('UTC', timeofday()::timestamptz):timestamptz;

Why do I get the timezone value as being -07(my local offset), instead
of -00?

Thanks,
Steve



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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: timezone() with timeofday() converts the wrong direction?
Следующее
От: Thomas Hallgren
Дата:
Сообщение: Returning a RECORD, not SETOF RECORD