Miscellany

Perl and MYSQL .....Datetime problem..
======================================
in perl I am getting date with localtime() ...
inserting successfully in MYSQL with data type of field is varchar...
but unable to insert the date when MYSQL file datatype is datetime...

any help???