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

• Re: time + date_part oddness? at 2001-01-05 06:49:36 from Thomas Lockhart

pgsql-hackers by date

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