Thread

date_part() BUG?

Roberto João Lopes Garcia <roberto@mha.com.br> — 1999-02-11T14:28:02Z

I´m making tests for data types and I wonder if the following  is a bug!

using age() function I get: @ 1 hour 13 mins 27.88 secs
using date_part() over age() I get:

1 for 'hour'   OK!
13 for 'minute'   OK!
27.8765430000003  for 'second'   OK!
0 for 'day'   OK!
0 for 'month'   OK!
0 for 'year'   OK!

But

1 for 'decade'     NOT OK!
1 for 'century'    NOT OK!
1 for 'millenium'    NOT OK!

See trancrition bellow

cd=> \d th

Table    =
th
+----------------------------------+----------------------------------+--
-----+
|              Field               |              Type
 |
Length|
+----------------------------------+--------------------------------
--+-------+
| data                             | date
      |     4 |
| hora                             | time
          |     8 |
| ms                               | int4
              |     4 |
| dt                               | datetime
                  |     8
|
+----------------------------------+----------------------------------+---
----+
cd=> select * from th
cd-> \g
data      |hora    |        ms|dt


----------+--------+----------+--------------------------
11/02/1999|10:33:
31|1234567890|11/02/1999 10:33:31.12
EDT
11/02/1999|10:33:31|1234567890|11/02/1999 10:33:31.13 EDT
(2
rows)

cd=>   select age('now', dt)   , date_part('millenium', age('now',
dt)::timespan), date_part('century', age('now', dt)::timespan),
date_part('decade', age('now', dt)::timespan) , date_part('year',
age('now', dt)::timespan), date_part('month', age('now', dt)::timespan),
date_part('day', age('now', dt)::timespan) , date_part('hour', age('now',
dt)::timespan)  , date_part('minute', age('now', dt)::timespan) ,
date_part('second', age('now', dt)::timespan) from th\g
age

|date_part|date_part|date_part|date_part|date_part|date_part|date_part|date_
part|
date_part
---------------------------+---------+---------+---------+--------
-+---------+---------+---------+---------+----------------
@ 1 hour 13 mins
27.88 secs|        1|        1|        1|        0|        0|        0|
   1|       13|27.8765430000003
@ 1 hour 13 mins 27.87 secs|        1|
  1|        1|        0|        0|        0|        1|
13|27.8654319999996
(2 rows)

cd=> 

------------------------------------------------------------------
Eng. Roberto João Lopes Garcia         E-mail: roberto@mha.com.br
F. 55 11 848 9906   FAX  55 11 848 9955

MHA Engenharia Ltda
E-mail: mha@mha.com.br    WWW: http://www.mha.com.br

Av Maria Coelho Aguiar, 215 Bloco D     2 Andar
Centro Empresarial de Sao Paulo
Sao Paulo - BRASIL - 05805 000
-------------------------------------------------------------------