From: | Siim Valgeväli <siim(dot)valgevali(at)ttu(dot)ee> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Small bug report ... |
Date: | 2001-10-06 07:48:08 |
Message-ID: | 001801c14e3b$3dcfa560$462111ac@radiolinja.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello!
I found a small mistake from age() function.
The query is for example: SELECT age('1980-05-08');
and expected output should be "21 years 4 months 29 days 01:00"
but PostgreSQL version
"PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96"
gave this result:
"21 years 4 mons 29 01:00"
It should be "21 years 4 MONTHS 29 DAYS 01:00"
-----
Some more examples:
INPUT: "select age('1982-06-15');" OUTPUT: "21 years 4 mons 29 01:00"
INPUT: "select age('2001-09-05');" OUTPUT: "1 mon 1 00:00" etc.
I am sorry, but I really don't know mabye on PostgreSQL version 7.0.3 it works properly.
But aniway, PostgreSQL is my favourite!!
---
best regards,
Siim Valgeväli
Estonia
siim(dot)valgevali(at)ttu(dot)ee
From | Date | Subject | |
---|---|---|---|
Next Message | John Summerfield | 2001-10-06 12:24:35 | Problem building from CVS |
Previous Message | John Summerfield | 2001-10-05 23:56:38 | Re: Long options for psql in 7.1.3 |