I’m working with MySQL and I need to store the working hours for multiple shops. Is there a good way to store all of the information regarding the open and close time of shops so it’s well-organized?
Tutorials
- ABAP Definition & Full Form
- SAP ABAP Certification Cost
- SAP ABAP Course Detail & Scope
- ABAP Interview Questions
- ABAP Syntax
- ABAP Date & Time
- ABAP Internal Tables
- ABAP Table Control
- ABAP Data Dictionary
- ABAP Views Types
- ABAP Loop At Where
- ABAP Module Pool Program
- ABAP Search Help
- ABAP Trigger Event
- ABAP Native vs. Open SQL
- ABAP Function Modules
- ABAP OOPs
- ABAP Data Types and Objects
- ABAP Classes
- ABAP Smartforms
- ABAP Sapscript Layout
- ABAP BADI Step by Step
- ABAP BAPI List
- ABAP WEB DYNPRO
- ABAP ALV
- ABAP Core Data Service
- ABAP Trim or Condense Spaces
- ABAP Convert Currency Format
- ABAP Delete Leading Zeros
- ABAP Use Search Help in Selection Screen
- SAP Tcode SE16 vs SE16N
Get solutions from our experts!
In the case of the normal operating hours, I would create a table (ShopTimes) containing the following columns:
TableName: ShopTimes
ShopTimeID int Auto_Increment
ShopID int -- Note: This assumes another table with the ShopID, ShopName, etc.
WeekDayNo int -- Note: This assumes the use of DayOfWeek() to get this number
OpeningTime DateTime -- Note: Use of DateTime should make it easier to calculate calendar
ClosingTime DateTime -- DateTimes based on a date plus these column values
In the case of actual shop openings and closings:
TableName: ShopTimesHistory
ShopTimeHistoryID int Auto_Increment
ShopID int -- Note: This assumes another table with the ShopID, ShopName, etc.
WeekDayNo int -- Note: This assumes the use of DayOfWeek() to get this number
OpeningTime DateTime -- Note: In this case, the complete datetime from the actual opening
ClosingTime DateTime -- and closing should be recorded