Re: [SQL] selecting current UTC time

[EMAIL PROTECTED] wrote: 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_timesta

[SQL] selecting current UTC time

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.844