Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group