Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Date Convert

by Anonymous Monk
on Jan 09, 2013 at 19:05 UTC ( #1012545=perlquestion: print w/ replies, xml ) Need Help??
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks!
I have date format like this: "01/09/2012" that is getting inserted into sql server, I am getting errors, I am trying to convert into a sql format, something like this:
... my $date = "01/09/2012"; $date = strftime '%Y-%m-%d %H:%M:%S', $date; print $date; ...

Any idea on how I could do this?
Thanks!

Comment on Date Convert
Download Code
Re: Date Convert
by roboticus (Canon) on Jan 09, 2013 at 19:26 UTC

    If it's a fixed format input string, I wouldn't bother with strftime. I'm guessing that something as simple as the following should work:

    my $date = "01/09/2012"; $date = join("-", reverse split /\//, $date), " 12:00:00";

    ...roboticus

    When your only tool is a hammer, all problems look like your thumb.

Re: Date Convert
by Anonymous Monk on Jan 09, 2013 at 20:42 UTC
    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?)
      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.

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

      Many TIA
      Helen

Re: Date Convert
by mhearse (Hermit) on Jan 09, 2013 at 21:34 UTC
    Why not use epoch? Can be handled with a unsigned int data type.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2014-08-30 13:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (293 votes), past polls