| SitePoint Sponsor |
Hello everyone!
I am trying to run a query and am getting this error #1067 - Invalid default value for 'created' and this is the line where the error occurs
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
Can someone point me what I am doing wrong
Do you get bothered because I do the same thing every day?
Do you question why I do it?
Then find something that you actually like doing!!!
Stop thinking on what I do.
Well I figured what the problem was, accepted values start at 1000-01-01
Do you get bothered because I do the same thing every day?
Do you question why I do it?
Then find something that you actually like doing!!!
Stop thinking on what I do.
why would you want a "created" column to default to 0000-00-00?
it shouldn't be that hard to assign the current date and time to it
what do you actually need here? can i see your INSERT statement?
I don't have the insert statement but it will insert current date time, that was not my problem, my problem was when adding the tables to the database but it is done, thank you.
Do you get bothered because I do the same thing every day?
Do you question why I do it?
Then find something that you actually like doing!!!
Stop thinking on what I do.
Posting Permissions
Reply With Quote
Bookmarks