Re: storing start/end times
Posted by: Dimitris Papageorgiou
Date: April 15, 2015 08:39AM

I have managed after all(by reading the article which link you gave me) to create a calendar table.

So here is the issue now:

How am I suppose to "connect" the stores_open table with the calendar table...

Suppose the store owner goes to fill open/close hours for Monday-at this point do I have also to store the date(that references the calendar table) for that day...and after that a week or two pass...how the date for Monday is going to be updated automatically in the stores_open table.

In general..I have not quite understood how the stores_open table will be "connected" to the calendar table-the logic behind it.

Options: ReplyQuote


Subject
Written By
Posted
Re: storing start/end times
April 15, 2015 08:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.