Re: [HACKERS] date_part() BUG?

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Roberto Joao Lopes Garcia <roberto(at)mha(dot)com(dot)br>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] date_part() BUG?
Date: 1999-02-11 17:08:59
Message-ID: 36C30EAB.E0257FD6@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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:
<snip tests for years through seconds>
> But
> 1 for 'decade' NOT OK!
> 1 for 'century' NOT OK!
> 1 for 'millenium' NOT OK!

I can see that here. Will look at it. Thanks for the report...

- Tom

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jackson, DeJuan 1999-02-11 17:15:09 Temp tables
Previous Message Vadim Mikheev 1999-02-11 17:04:33 Re: [HACKERS] TIME QUALIFICATION