select current UTC time ?

Поиск
Список
Период
Сортировка
От kevin kempter
Тема select current UTC time ?
Дата
Msg-id 1CA79562-D691-430C-B1EC-9931EF0BF7C2@kevinkempterllc.com
обсуждение исходный текст
Ответы Re: select current UTC time ? (SOLVED)  (kevin kempter <kevin@kevinkempterllc.com>)
Re: select current UTC time ?  ("Scott Whitney" <swhitney@journyx.com>)
Список pgsql-admin
Дерево обсуждения 
Hi List;

How could I select the current UTC time ?  now() cast as a timestamp
at UTC is wrong because it takes now() and says: if it were now() time
UTC what would it be here (timezone) and returns that. I want to
return 'what time is it now in UTC ?'

Thanks in advance...

/Kevin

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Is it possible to convert WAL's between architectures?
Следующее
От: kevin kempter
Дата:
Сообщение: Re: select current UTC time ? (SOLVED)