Postgres Pro
Downloads
Home   >   mailing lists

select current UTC time ? - Mailing list pgsql-admin

From kevin kempter
Subject select current UTC time ?
Date
Msg-id 1CA79562-D691-430C-B1EC-9931EF0BF7C2@kevinkempterllc.com
Whole thread Raw
Responses Re: select current UTC time ? (SOLVED)
Re: select current UTC time ?
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Is it possible to convert WAL's between architectures?
Next
From: kevin kempter
Date:
Subject: Re: select current UTC time ? (SOLVED)