[SOLVED] Â MySQL query for time chart |
2/3/2021 8:23:34 PM |
PHPRunner General questions | |
D
DealerModules authorDevClub member
I have a field called 'datepromised' that has data like:
|
|
N
|
Nir Frumer 2/4/2021 |
hi |
![]() |
Sergey Kornilov admin 2/4/2021 |
What Nir says, you need some sort of a temporary/additional table that would contain all 24 hours. Then you LEFT JOIN the results of your query with this table and those entries that don't have a value will have NULLs in the results. |
D
|
DealerModules authorDevClub member 2/4/2021 |
Thanks Nir and Sergey. |