On Mon, 13 Oct 2003, Flavio S. Glock wrote: > How about a question for the FAQ? > > http://perlmonks.org/index.pl?node_id=298788 > > > > Calculate down time of devices in prime time (only working hours, excluding > > p_holidays) > > by albertc on Oct 13, 2003 at 05:00 GMT+3 > > > > I have up & down datetime data for devices, I need a function that will provide the > > downtime within the primetime period. Input will be d_time, u_time, stime > > (starting time > > for Primetime, 08:00:00), etime (endtime for PrimeTime, 18:59:59). The function > > also > > needs to remove downtime that occured on a public holiday and over weekends! Public > > holidays will be read from mysql table with Datetime record of each public holiday.
Unfortunately, I don't know that we have a great solution yet, do we? I think this could be done with a bunch of spanset intersections, but ideally there'd be business modules to handle a lot of this. -dave /*======================= House Absolute Consulting www.houseabsolute.com =======================*/