Hello guys,
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
193138.000,070610,
182605.000,190810,
051953.000,200810,
174651.000,210810,
140341.000,120610,
150441.000,130610,
131631.000,100610,
125717.000,110610,
144634.000,080610,
182417.000,050710,
142139.000,070710,
Thanks
Paul