selecting current UTC time - Mailing list pgsql-sql

From
Subject selecting current UTC time
Date
Msg-id f0e0f1b15551d000d53e665dd7c31d80@imap.xnet.co.nz
Whole thread Raw
Responses Re: selecting current UTC time  (Frank Bax <fbax@sympatico.ca>)
List pgsql-sql
Hi,

Is it possible to select the current UTC time as type timestamp with time
zone?

select localtimestamp;

2008-09-14 21:55:24.367796

select localtimestamp at time zone 'UTC';    
2008-09-15 09:55:42.3478+12
(not sure if what this result is)

select current_timestamp;

2008-09-14 21:55:57.844422+12

select current_timestamp at time zone 'UTC';

2008-09-14 09:56:07.661157
(is type timestamp without time zone)

I know this seems like a simple problem but I have searched the archives
and am unable to find a solution.

Any ideas?

Thanks.




pgsql-sql by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Pls Hlp: SQL Problem
Next
From: Frank Bax
Date:
Subject: Re: selecting current UTC time