Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
I've got a mySQL table with rows that will each contain a date/time (currently in time() format). I'd like to be able to input two times in month/day/hour/minute format and return all database entries that fell between those two dates and times.
Is there a way to do this without using Date::Calc, possibly with using a different date/time format in mySQL? Another module? Date::Calc looks like it would be lighting a campfire with an ICBM.
Thanks.
Is there a way to do this without using Date::Calc, possibly with using a different date/time format in mySQL? Another module? Date::Calc looks like it would be lighting a campfire with an ICBM.
Thanks.
|
---|
Replies are listed 'Best First'. | |
---|---|
(Ovid) Re: unix time and dates with mysql
by Ovid (Cardinal) on Feb 26, 2002 at 23:33 UTC | |
Re: unix time and dates with mysql
by grep (Monsignor) on Feb 26, 2002 at 23:32 UTC | |
by lachoy (Parson) on Feb 27, 2002 at 01:19 UTC | |
Re: unix time and dates with mysql
by cayenne (Scribe) on Feb 27, 2002 at 00:44 UTC | |
Re: unix time and dates with mysql
by jonjacobmoon (Pilgrim) on Feb 27, 2002 at 00:33 UTC | |
Re: unix time and dates with mysql
by strat (Canon) on Feb 27, 2002 at 09:48 UTC |
Back to
Seekers of Perl Wisdom