time + date_part oddness?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: time + date_part oddness?
Date: 2001-01-05 01:00:42
Message-ID: 20010105100042N.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I am writing an article of PostgreSQL 7.1 and have some questions.

I can get the millisecond part of a timestamp data using date_part.

test=# SELECT date_part('millisecond','2001/1/15 12:04:05.1234'::TIMESTAMP);
date_part
-----------
123.4
(1 row)

However if I apply the function to a time data, I get a strange result.

test=# SELECT date_part('millisecond','12:04:05.1234'::time);
date_part
------------------
5123.39999999676
(1 row)

Any thought?

(This is current)
--
Tatsuo Ishii

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew 2001-01-05 01:14:59 RE: pg_dump return status..
Previous Message Tom Lane 2001-01-04 23:25:01 Re: Missing ColLabel tokens