in reply to STR_TO_DATE in Perl code
Prepare INSERT INTO tablename (name,trans_date,price) VALUES( STR_TO_DATE(?,'%m/%d/%Y'), ?, ? );
Then $insert->execute( $name, $dt, $prc );
See DBI Placeholders and Bind Values, quote_identifier, quote
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: STR_TO_DATE in Perl code
by baperl (Sexton) on Aug 01, 2011 at 16:36 UTC |