SQL: SELECT CURDATE()+0; RESULT: 20040331
Thats good. However consider this:
SQL: SELECT CURDATE()+1; RESULT: 20040332
Not so good. Infact with this version any WHERE clauses you would put this in, fails to bring back the right result.
Does CURDATE() support numeric addition like this? Or is the "+0" purely a casting-hack to get the right format. Its not meant as pure addition.
Thoughts?
thanks
alan
-- Alan Williamson, City Planner
w: http://www.BLOG-CITY.com/ e: [EMAIL PROTECTED] b: http://alan.blog-city.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]