Perl, SQL and the DateTime datatype

[Weir, Jason - Contractor]

ok, I need to write a date time stamp to a SQL database but when using the
following code I get a date format error, does anybody know what the correct
format for the date is when using the DateTime datatype in SQL

$DTG = localtime();
$sth = $dbh -> prepare ("INSERT INTO $table VALUES ('$DTG')");


Thanks,
Jason Weir
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs