From: | "Scott Whitney" <swhitney(at)journyx(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: select current UTC time ? |
Date: | 2008-06-05 19:12:36 |
Message-ID: | 20080605190932.926723E20E8@mail.int.journyx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
This seems to work for me:
template1=# select now() at time zone 'UTC';
timezone
----------------------------
2008-06-05 19:08:50.590806
(1 row)
template1=# select now();
now
-------------------------------
2008-06-05 14:08:57.278037-05
Cheers.
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of kevin kempter
Sent: Jun 05, 2008 2:01 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] select current UTC time ?
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-06-05 22:18:28 | Re: Is it possible to convert WAL's between architectures? |
Previous Message | kevin kempter | 2008-06-05 19:12:21 | Re: select current UTC time ? (SOLVED) |