Re: select current UTC time ?

kevin kempter wrote:

>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 ?'

SELECT EXTRACT('epoch' FROM CURRENT_TIMESTAMP AT TIME ZONE 'UTC')::bigint::int

Rainer