I have a CSV file where one column has a date in the format DD/MM/YY.
When i import this into a tinyblob field, it becomes YYYY-MM-DD HH:MM:SS.
How can i store it in the original format?
Im not bothered if it is actually seen as a date, i just need to grab it as a string in my PHP code.
Thanks
Mark
Importing dates from CSV
Moderator: General Moderators
Aha, using 3rd part software.
If you still experience problems, try using phpMyAdmin or MySQL-Front (GUI software) that also supports CVS's.
Perhaps it's an issue in the software. Just thoughts...
If you still experience problems, try using phpMyAdmin or MySQL-Front (GUI software) that also supports CVS's.
Perhaps it's an issue in the software. Just thoughts...