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