Re: FN-FORUM: php date function

date posted 9th May 2006 16:51

> I'm storing the date in an 2006-01-01 format.

Presumably a MySQL date field, rather than a character field?

> or maybe there is another way of outputting it?

I'd do it in the SQL query, using the MySQL date functions.

"SELECT DATEDIFF(visited,NOW()) as days FROM..."

From the manual: DATEDIFF() returns the number of days between the star=
t =

date expr and the end date expr2

Anthony
-- =

www.fonant.com - hand-crafted web sites