trying tio import a database into phpmyadmin, but kept getting this error. see, this date i was originally putting it in there becasue when i initially imported the databse, some entries didnt have “created” date so i made one up.
i edited some entries and when i went to import it now its still complaining saying
but how can that be incorrect? i mean in the databse its listed as 1970-01-01 00:00:00 but when i exported to excel it comes up as 1/1/1970 0:00
of course i tried to convert it but that gave the same error. any idea?
r/PHPhelp
Excel does its own thing in date cells. Change the column format to “general” or “text”.
It’s your Excel export, fix the format there,. Export as CSV and then import in MySQL.
Post the specific insert / default value clause you have
sorry im new with database stuff. but im not using a query, its just excel csv file import
Members
Online