From: | kevin kempter <kevin(at)kevinkempterllc(dot)com> |
---|---|
To: | kevin kempter <kevin(at)kevinkempterllc(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: select current UTC time ? (SOLVED) |
Date: | 2008-06-05 19:12:21 |
Message-ID: | 60D3B084-DC72-4C91-A0E5-F064590E3D79@kevinkempterllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Whitney | 2008-06-05 19:12:36 | Re: select current UTC time ? |
Previous Message | Rainer Bauer | 2008-06-05 19:08:35 | Re: select current UTC time ? |