Re: How to store opening time of shops?

On 17-3-2019 12:39, ^Bart wrote:
> I should store opening time of shops but I think I can't use just one
> field!

of course it can be done in 1 field!

CREATE TABLE openingtimes(

      storeid integer
, times varchar(2000)
, primary key(storeid)
);

use i.e. a value like this for the field 'times': 'opened from Monday till Tuesday during working hours, not while siësta'

;)

>
> There are shops opened every days from 08:00 am to 08:00 pm others
> opened just few days and not with the same time every days... :\
>
> How could I solve this problem?
>
> Regards.
> ^Bart

-- 
Luuk