date-math Archives

How can I use mysql to determine the Sundays for the last year?

By adminPosted on September 27, 2022

Question : I have a table where I’m currently aggregating ~200 rows per day of stats. These stats include things […]

By adminPosted on September 11, 2022

Question : How can i merge only the dates occur subsequently.? (i.e, The Next Event begins immediately after the previous […]

By adminPosted on August 31, 2022

Question : I have the following table with the following data: DECLARE @MyActions TABLE (ActionId INT NOT NULL, ActionDate DATETIME […]

By adminPosted on July 19, 2022

Question : I have a table as below: Name Start Date End Date Joe 20/04/2021 20/05/2021 John 01/05/2021 28/05/2021 I […]

By adminPosted on January 27, 2022

Question : I’m having a problem: I’m trying to calculate days between two dates. Let’s say I have the date […]

By adminPosted on November 30, 2021

Question : I have seen on this site how to get the the third Friday of the month: select quote_date […]

By adminPosted on August 1, 2021

Question : I am using SQL Server 2016 I have a table that contains 1 row per month that a […]

By adminPosted on July 24, 2021

Question : I have a daily appending table, that I need a formula for that would filter the table results […]

By adminPosted on June 20, 2021

Question : Example: If the current time is 2018-05-17 22:45:30 and the desired interval is INTERVAL ‘5 minute’, then the […]

By adminPosted on May 12, 2021

Question : I have table with following data id start_date end_date 1 2018-01-01 2018-01-15 2 2018-01-11 2018-01-16 3 2018-01-03 2018-02-10 […]