I'm trying to get the difference (in days) between dates stored in two date fields.
My query:
SELECT id,(firstdate- postdate) AS diff FROM calendar
This works fine if the two dates are in the same month, but not otherwise. MySQL appears to be treating the two dates as base-10 integers rather than dates. E.g.:
2004-01-07 (20,040,107) - 2003-12-31 (20,031,231) = 8876
How do I get MySQL to treat these date fields as date fields in this case?
Thanks,
Kenneth
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]