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?)
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. | [reply] |
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
| [reply] |
|