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.