I have searched the forum and reviewed responses to questions related to mysql date format. However, none of these responses seem to solve my problem and therefore need put it forward hoping that someone could help.
I have set up my mysql database and populating the tables using import command to import data from text files. The date from the text file is in the form “190810” i.e d.m.y. After populating my tables I realised that the mysql is truncating the date entry and producing extraordinary dates upto year 2013, 2021 and so on in in its default format. I thought mysql could reverse the date as in changing 190810 to 2010-08-19.
I am aware if you are retrieving data you can display the date as you want it. I am not retrieving data in this case but storing data from a text file which has date that must not be truncated.
So how do I import this data from the text file and maintaining the correctness of the date even if it is in mysql default format. Is there no other way I can achieve this. I am completely run out of ideas. Please advise.