On Jun 5, 2008, at 1:01 PM, kevin kempter wrote:
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Ignore this post, the first query gives me the right answer [as does :
select timeszone('UTC', now()) ] - neurons firing slowly today.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
