| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | timestamp_part() bug? |
| Date: | 2002-02-27 08:07:50 |
| Message-ID: | 20020227170750O.t-ishii@sra.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I see following in the manual:
-------------------------------------------------------------------
The seconds field, including fractional parts, multiplied by
1000. Note that this includes full seconds.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT EXTRACT(MILLISECONDS FROM TIME '17:12:28.5');
Result: 28500
-------------------------------------------------------------------
And I see:
test=# select current_timestamp,extract(milliseconds from current_timestamp);
timestamptz | date_part
-------------------------------+-----------
2002-02-27 14:45:53.945529+09 | 945.529
(1 row)
Apparently there's an inconsistency among manuals, timestamp(tz)_part
and timetz_part. Does anybody know which one is correct?
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 2002-02-27 08:09:45 | LRU and full table scans |
| Previous Message | Jean-Michel POURE | 2002-02-27 07:58:25 | Re: PostgreSQL 8.0 ?? |