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
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?

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