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: (view raw, whole thread or download thread mbox)
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);
(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);
(1 row)

Any thought?

(This is current)
Tatsuo Ishii


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-2018 The PostgreSQL Global Development Group