Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://76852]
help
Chatterbox?
[james28909]: howdy, could a kind monk help me test connectivity to my ftp server? i cannot connect to it from within my home network behind a public ip (i have a dynamic ip) and just need to make sure users can connect.
[james28909]: oh nevermind, i see one of the users in the list of connected users now. thanks!
erix could you an extra bit of cloud too

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (7)
As of 2017-07-27 14:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I came, I saw, I ...
























    Results (416 votes). Check out past polls.