Here simple as this, MySql Database, the field "date_in" is set as type datetime.

...
my $datetime = sprintf("%4d-%02d-%02d %02d:%02d:%02d.000",Today_and_No
+w());
...
my $sth = $dbh->prepare("INSERT INTO mytable(name,date_in) values(?,?)
+")                                            ,$dbh->errmsg);   
$sth->execute($name,$datetime);
...
[download]

Thanks