in reply to
DBI:mysql date conversion question
The following is the syntax of STR_TO_DATE.
STR_TO_DATE('00/00/0000', '%m/%d/%Y');
[download]
In your insert statement, '%' symbol is missing for year(Y) format string. Also a bracket( ")" ) is missing at the end of the insert statement.
And also check the value of '$frame_installdate' before the insert statement.
Comment on
Re: DBI:mysql date conversion question
Download
Code
In Section
Seekers of Perl Wisdom