bug in current_timestamp(1)

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: bug in current_timestamp(1)
Date: 2003-07-30 02:59:04
Message-ID: 09b301c35646$89d14a80$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-07-30 04:38:54 Re: Upgrading my BSDI box, again
Previous Message Rod Taylor 2003-07-30 02:11:15 Re: using adbin, conbin, etc.