select current UTC time ?

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: select current UTC time ?
Date: 2008-06-05 19:01:13
Message-ID: 1CA79562-D691-430C-B1EC-9931EF0BF7C2@kevinkempterllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rainer Bauer 2008-06-05 19:08:35 Re: select current UTC time ?
Previous Message Alvaro Herrera 2008-06-05 15:19:32 Re: Is it possible to convert WAL's between architectures?