Re: timestamp_part() bug?

On Wed, Feb 27, 2002 at 05:07:50PM +0900, Tatsuo Ishii wrote:
> 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?

I hope bug is in the manual -- for example minutes the "extract" returns
without hours. Is any matter why returs millisecons with seconds?
If somebody wants milliseconds with seconds:

# select extract(SECONDS from '14:45:53.945529'::time) * 1000;
?column?
------------------
53945.5289999969
(1 row)

BTW, to_char() retuns milliseconds without seconds too:

test=# select to_char('2002-02-27 14:45:53.945529+09'::timestamp, 'MS');
to_char
---------
946
(1 row)

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz