Syntactic Confectionery Delight | |
PerlMonks |
Re^3: Place Holders and SQL convertby Corion (Patriarch) |
on Sep 17, 2015 at 18:11 UTC ( [id://1142344]=note: print w/replies, xml ) | Need Help?? |
I am really, really confused. The error message you get is from your SQL server. It has nothing to do with Perl. You cannot change your data format without also changing your data. In your first example, you have yyyy-mm-dd, in this example you have mm-dd-yyyy . You will need to decide on one format and then check that both, your data and the other arguments to convert() match that.
In Section
Seekers of Perl Wisdom
|
|