Hi,
I have a table full of activity records. Each record has a DATETIME
field for when the activity started and one for when it ended.
I want to post process this table and produce billing records from it.
Billing records will have a link back to the activity record that
produces them; i.e. there could be more than one billing record for
each event. The reason for this is that there are different billing
rates per event type and also different rates depending on the time
of day ["office hour" rates are different than early morning, evening,
night/weekend rates].
Let's say that office-hour-rates start from 8am - 4:59:59pm Monday
- Friday. Everything else is a night/weekend rate.
It is easy to get the records where the event start/stop DATETIMES are
in the same day and are both in or out of the "office hours" range.
it is fairly easy to get the records the event start/stop DATETIMES
are in the same day and the start record is "early morning" and the
stop record is "business hours" or the start record is "business"
and the end os evening.
Let's say that I have an activity record that starts at 6am.
It continues all day until 9pm that same evening. I would want to
prodauce three billing records:
06:00:00 - 07:59:59
08:00:00 - 16:59:59
17:00:00 - 21:00:00
What if the activity flows over a day change? More than one day
cahnge?
Should I just punt and return the activity DATETIMES as UNIX_TIMESTAMPs
and do the date manipulation myslef?
Dean...K...
--
Dean Karres / karres at itg dot uiuc dot edu / www.itg.uiuc.edu
Imaging Technology Group / Beckman Institute
University of Illinois
405 North Mathews / Urbana, IL 61801 USA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
