Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^3: Place Holders and SQL convert

by Corion (Patriarch)
on Sep 17, 2015 at 18:11 UTC ( [id://1142344]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Place Holders and SQL convert
in thread Place Holders and SQL convert

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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1142344]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (6)
As of 2024-04-19 06:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found