I have a database table with a datetime column. Everything works fine if a make an Insert using the current date :
INSERT INTO table VALUES ('field1', now(), 'field2');
But it returns NULL when I try to insert a date in the future. I do this :
INSERT INTO table VALUES ('field1', '2011-07-01 00:00:00', 'field2');
What's wrong with this query ??
nb. It works fine when I insert the current date, and then make an update using DATE_ADD() But it's complicated, there's nothing easier to do this ??
thanks !