Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
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?)

Replies are listed 'Best First'.
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?
[ELISHEVA]: the data source, or one of them, is the OECD - they provide a *lot* of data that ought to be easily available to perl programmers.
[erix]: it might be cunning to mention the module in the title... :)
[ELISHEVA]: fancy that - a title that actually describes the problem :-)
[ELISHEVA]: but actually thanks for the reminder
[Discipulus]: DBI::CSV + utf8 = BOO?M
[erix]: in extremis we tend to forget stuff ;)
[ELISHEVA]: \Disciplus : lol
[Discipulus]: and ELISHEVA we waait one your post since ~2years... ;=)
[ELISHEVA]: has it really been that long?
[Discipulus]: it seems..

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (8)
As of 2017-05-28 20:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?