Find how many x-day intervals have passed since outset and another date-CodePudding

Home > Software engineering > Find how many x-day intervals have passed since outset and another date

Find how many x-day intervals have passed since outset and another date

Time：01-09

In SQL, how can I calculate how many x-day intervals have passed since outset date?

Consider 2023-01-11 as an example for such an "outset date". For any subsequent date, I want to know how many 4-day intervals have passed since the outset date. For example:

Page link：https//www.codepudding.com/Softwareengineering/666406.html

Prev:How do I select all values which satisfy certain aggregate properties?

Next:I need to match special character, how can I write query to get the required output?

Tags：

sqldate

Links：
CodePudding