writing a simple perl script to wrangle data; format date column : I want to reformat my data to populate a db.

I was going to try perl or awk; I would like to use perl here, below is a small sample of a 9GB file I want to reformat.

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/Hx96V.png

One can see that first two column/fields seperated by delimiter ',' are `20140303,9:30:00` and I need to change this into MySQL DateTime format : "The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format."  
  
I see on several posts that perl has a DateTime module and would like to use that but also need to learn to parse/reformat field of file use perl.

I will appreciate help in expediting my attempt to write this simple script while I have started reading 'Learning Perl the hard way' to get a taste of perl.

Thanks 