What's with this?
template1=# select current_timestamp(0);
timestamptz
------------------------
2002-08-21 16:39:40+08
(1 row)
template1=# set time zone 'Australia/Sydney';
SET
template1=# select current_timestamp(0);
timestamptz
------------------------
2002-08-21 18:39:49+10
(1 row)
template1=# select current_timestamp(0) at time zone 'Australia/Sydney';
ERROR: Time zone 'australia/sydney' not recognized
template1=# select current_timestamp(0) at time zone 'AEST';
timezone
---------------------
2002-08-21 18:40:07
(1 row)
Shouldn't the textual version of the time zone work using 'at time zone' as
well as 'set time zone'?
And also, why does the column name change from timestamptz to timezone?
Anyway, shouldn't it in fact be current_timestamp?
Chris
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
