> 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
