Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Convert US dates to mySQL dates

by sutch (Curate)
on May 01, 2001 at 05:18 UTC ( #76852=note: print w/ replies, xml ) Need Help??


in reply to Convert US dates to mySQL dates

I had a similar problem earlier today. I needed a method to parse human-readable dates that were generated by various systems. I found that the Time-modules, and specifically Time::ParseDate, should be able to convert various date formats to the time in seconds since January 1st, 1970 (the epoch).

This solves the most difficult part of your problem. I'm not sure if there is a module that handles the conversion to MySQL format--in the past I've used localtime to do these types of conversions.


Comment on Re: Convert US dates to mySQL dates

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (12)
As of 2014-10-21 15:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (105 votes), past polls