All pastes #184877 Raw Edit

Anonymous

public text v1 · immutable
#184877 ·published 2006-09-28 11:19 UTC
rendered paste body
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???

 $callstart = localtime();
 $dbh->do("INSERT INTO CDR(CallTime) VALUES (" . $dbh->quote($callstart) . ")");

}