Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Thank you everyone for the help. Sorry there wasn't much detail given originally.
CURRENT_TIMESTAMP at time zone 'UTC' as ct4
On Tue, Feb 27, 2018 at 1:16 PM, chris <chrisk@pgsqlrocket.com> wrote: What is the best way of selecting current timestamp in UTC? You haven't define d criteria upon which to judge - and the list below is not exhaustive (but sufficiently so)SELECTCURRENT_TIMESTAMP as ct1standard conforming, assumes server configured for UTC ,timezone('UTC',CURRENT_TIMESTAMP) as ct2,timezone('utc',now()) as ct3non-standard, personally non-obvious (the function looks like an implementation detail that should be avoided),CURRENT_TIMESTAMP at time zone 'UTC' as ct4This -standard conforming and doesn't require assumptions about the calling environment,NOW() at time zone 'utc' as ct5non-standard but frequently used; no semantic different compared to the previous entryDavid J.
What is the best way of selecting current timestamp in UTC?
SELECTCURRENT_TIMESTAMP as ct1
,timezone('UTC',CURRENT_TIMESTAMP) as ct2,timezone('utc',now()) as ct3
,CURRENT_TIMESTAMP at time zone 'UTC' as ct4
,NOW() at time zone 'utc' as ct5
В списке pgsql-general по дате отправления: