Going from precision 3 down to 0 - note the bug in (1). It always displays
a trailing zero.
australia=# select current_timestamp(3);
timestamptz
----------------------------
2003-07-30 10:54:55.642+08
(1 row)
australia=# select current_timestamp(2);
timestamptz
---------------------------
2003-07-30 10:54:57.11+08
(1 row)
australia=# select current_timestamp(1);
timestamptz
---------------------------
2003-07-30 10:54:58.20+08
(1 row)
australia=# select current_timestamp(0);
timestamptz
------------------------
2003-07-30 10:55:03+08
(1 row)
Chris
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
