Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Date Convert

by Anonymous Monk
on Jan 09, 2013 at 20:42 UTC ( #1012569=note: print w/ replies, xml ) Need Help??


in reply to Date Convert

Use a date/time Perl object type that is friendly to DBI and specify the date value as a parameter to the query, so that DBI will recognize that the parameter is a binary value of date/time type and will bind to the parameter accordingly. Don't present it as a character string if you can avoid it. (Strange things can happen such as code that works in America but not in Europe where the "locale" is different: is "01/09/2012" January 9th or September 1st?)


Comment on Re: Date Convert
Re^2: Date Convert
by Anonymous Monk on Jan 09, 2013 at 20:50 UTC
    Thats the issue, to convert a string like "01/09/2012" into this date/time Perl object type that is friendly to DBI like you mentioned.
Re^2: Date Convert
by HelenCr (Monk) on Apr 19, 2013 at 13:26 UTC

    AM: your post sounds like the right thing. Can you please give a little code example, how to do it?

    Many TIA
    Helen

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (2)
As of 2014-09-18 04:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (108 votes), past polls