a generic answer - you say query so I assume the SQL language is involved -
almost all flavors of SQL have a function to determine day of week and they all have a date/time datatype -
so you want to use these capabilities to exclude certain rows
... WHERE ...
AND NOT ( < -- this will exclude rows that meet the following conditions
( DAY_OF_WEEK(date_column) = 'FRIDAY' < -- this varies depending on DB2 or Oracle or MySQL or ...
AND time_column > 23:00:00 )
(DAY_OF_WEEK(date_column) = 'SATURDAY')
(DAY_OF_WEEK(date_column = 'SUNDAY'
AND time_column < 23:00:00)
caveat - be very careful if you specify 11PM - do you really want 10:59:59 PM or 11:00:01 PM ?
Last Wiki Answer Submitted: July 30, 2009 3:33 pm by Meandyou5,205 pts.