OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Trigger and "Warning: #1265 Data truncated"

From: Keith Edmunds (kaemidnighthax.com)
Date: Tue Jun 09 2009 - 16:50:06 CDT

> 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