saulo Mendes wrote:
> age dt_nascimento
> 3 years 11 mons 30 days 18/12/2003
>
> supondo que a data "base" seja hoje (17/12) o resultado deveria ser
> 4 years 29 days
>
Ugh?! Não vi bug.
euler=# select * from foo;
a
------------
2003-12-18
2003-12-17
(2 registros)
euler=# select age(a),a,now()::date from foo;
age | a | now
-------------------------+------------+------------
3 years 11 mons 30 days | 2003-12-18 | 2007-12-17
4 years | 2003-12-17 | 2007-12-17
(2 registros)
--
Euler Taveira de Oliveira
http://www.timbira.com/
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
