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.