On Wed, Aug 26, 2015, at 10:17 AM, O. Klein wrote: > Those options don't fix my problem with closing times the next morning, > or is > there a way to do this?
Use the spatial model, and a time window of a week. There are 10,080 minutes in a week, so you could use that as your scale. Assuming the week starts at 00:00 Monday morning, you might index Monday 9:00-23:00 as 540:1380 Tuesday 9am-Wednesday 1am would be 1980:2940 You convert your NOW time into a "minutes since Monday 00:00" and do a spatial search within that time. If it is now Monday, 11:23am, that would be 11*60+23=683, so you would do a search for 683:683. If you have a shop that is open over Sunday night to Monday, you just list it as open until Sunday 23:59 and open again Monday 00:00. Would that do it? Upayavira
