Perl and MySQL....
In MySQL database I have a column with "DateTime" datatype
and in perl I am getting time with localtime() function...

but I am unable to insert locatime format in Datetime datatype ..
I have tried other MySql Datatypes for data/time but unable to
insert data except when datatype is varchar ....