Re: storing start/end times
Peter Brawley Wrote:
-------------------------------------------------------
> > in national holidays etc..
>
> If all the stores are in one country, here is one
> solution---keep a table of holidays(d date),
> populate it with dates for xmas, the national
> holiday, labour day &c, then populate the
> hoursopen table for each store with something like
> this ...
I assume there other solutions to it...this is just what you propose...I am not saying it is wrong.
> Then for store owners, build a monthly calendar
> interface from a query like ...
Why not just displaying a week a pick and enter from there...open/close hours for each weekday...
Why display the whole month?
> A column created as time default null will not do
> that.
Yes you are absolutely right...the problem appear only in Netbeans...if I enter null times from PHPMyAdmin there is no problem.