I have a series of data that I need to insert into a MySQL table using PHP (Codeigniter).
Problem: One of the data is a timestamp that looks like 06/01/12 01:43 PM
. However when I insert it into MySQL timestamp column, it becomes 0000-00-00 00:00:00
. How can I format the original format so I can insert it correctly into the timestamp col?