Hi all,
> Where did you get that idea? age's reference point is current_date (ie,
> midnight) not now(). There are also some differences in the calculation
> compared to a plain timestamp subtraction.
I'm jumping on this thread to point out a little strange thing to me.
CURRENT_DATE, converted (stupidly) as a string *with* hour is "current
date at mid-day":
test=# select to_char(current_date,'YYYY-MM-DD HH:MI:SS');
to_char
---------------------
2006-10-06 12:00:00
(1 ligne)
It was a day when I had to debug a strange behaviour in a customer's
(bad) code :-)
Cheers,
--
Jean-Paul Argudo
www.PostgreSQLFr.org
www.dalibo.com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
