Keep It Simple, Stupid | |
PerlMonks |
Coverting Date Formatsby tomazos (Deacon) |
on Mar 05, 2002 at 16:14 UTC ( [id://149414]=perlquestion: print w/replies, xml ) | Need Help?? |
tomazos has asked for the wisdom of the Perl Monks concerning the following question:
I want to insert some dates into a MySQL table. The data is from two sources.
One of them (an apache log), has the date format... "[27/Feb/2002:05:05:51 -0800]" ...which I assume I have to convert to 20020227050551 to get into MySQL.
The other one (a sybase dump), has the date format: "2002-02-23 01:27:25 -0800" Which I assume I have to convert to 20020223012725 to get into MySQL.
I suppose I could just write a complex regexp to convert, but is there any builtin/modules I could use to make the job easier? Any ideas appreciated.
Back to
Seekers of Perl Wisdom
|
|