Re^2: Place Holders and SQL convert

It could be this for MS SQL Server:

SELECT convert(datetime, '10-23-2016', 110) -- mm-dd-yyyy
[download]

But is the Perl format looked OK?

Comment on Re^2: Place Holders and SQL convert Download Code

Replies are listed 'Best First'.
Re^3: Place Holders and SQL convert by Corion (Patriarch) on Sep 17, 2015 at 18:11 UTC
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.	[reply] [d/l]