List:General Discussion« Previous MessageNext Message »
From:Keith Edmunds Date:June 9 2009 9:50pm
Subject:Re: Trigger and "Warning: #1265 Data truncated"
View as plain text  
> 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
Thread
Trigger and "Warning: #1265 Data truncated"Keith Edmunds5 Jun
  • Re: Trigger and "Warning: #1265 Data truncated"Walter Heck - OlinData.com5 Jun
    • Re: Trigger and "Warning: #1265 Data truncated"Keith Edmunds9 Jun