> Curdate() returns a datetime, which you are pushing into a date field. > It is truncating the time part. Just truncate it and you should be > fine :)
Hmmm. Not according to http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_curdate or, indeed, experiments: mysql> select curdate(); +------------+ | curdate() | +------------+ | 2009-06-09 | +------------+ 1 row in set (0.02 sec) So have I misunderstood your answer, or is there some other reason for the error I get? Thanks, Keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
