subject:"\[SQL\] selecting current UTC time"

Re: [SQL] selecting current UTC time

2008-09-14 Thread Frank Bax

[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

2008-09-14 Thread davidn

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