Re: How to store opening time of shops?

> And why not use TIME (see:
> https://dev.mysql.com/doc/refman/8.0/en/time.html)
>
> CREATE TABLE schedule (
>     storeid INTEGER
> ,    dow     INTEGER
> ,    opened  TIME
> ,    close   TIME
> ,       primary key(storeid, dow, opened)

[Quoted] I'm a MariaDB newbie, I'm sorry for my question but could you write me an example about how I could store something like:

Opening time (Monday->Friday)
08:30->12:30
15:00->19:00

Opening time (Saturday)
08:30->12:30

Closing time (Sunday)

Maybe I could set seven fields in a timetable one for every week's days?

Thank you very much for your patience! :)

^Bart Received on Mon Mar 18 2019 - 09:36:22 CET