Please do me a favour and suggest the way forward on this.
I have a php script which extracts data into text files. One of the fields in this text file is date in the format below: How can I preserve the correctness of the date to conform with the mysql default format. I am doing massive import of data from the text file and mysql is truncating the date like.
Please your opinion would be appreciated