If you use Date::Manip, you can set the Internal flag that tells it to return date-time strings without colons, which happens to be the same format that MySQL uses for timestamps:
use Date::Manip;
Date_Init("Internal=1"); # No colons in dates, same as mysql
my $end = ParseDate('today');
my $start = DateCalc('today', '- 5 days');