If you wanted to try a spatial approach that blended times like above, you could try a polygon of minimum width that spans the globe - this is literally using spatial search (geocodes) against time. So in this scenario you logically subdivide the polygon into 7 distinct regions (for days) and then within this you can defined, like a timeline, what open and closed means. The problem of 3AM is taken care of because of it's continuous nature - ie one day is adjacent to the next, with Sunday and Monday backing up to each other. Just a thought.
On Wed, Aug 26, 2015 at 5:38 AM, Upayavira <u...@odoko.co.uk> wrote: > > > 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 > -- Darren
