SQL statement used to calculate the number of days in the month and quarter of a given date

SQL statement used to calculate the number of days in the month and quarter of a given date

SQL statement used to calculate the number of days in the month and quarter of a given date

SQL statement used to calculate the number of days in the month and quarter of a given date

Declare @ date datetime;
Set @ date = getdate ()
-- The number of days between the first day of the month and the next day of the month
Select datediff (day, dateadd (month, datediff (month, 0, @ date), 0), dateadd (month, 1 + datediff (month, 0, @ date ), 0 ))
-- Simplify with variables
Select @ date = dateadd (month, datediff (month, 0, @ date), 0) -- the first day of the month
Select datediff (day, @ date, dateadd (month, 1, @ date ))
-- Another idea: specify the date of the last day of the month as the number of days of the month.
Select day (dateadd (month, datediff (month,-1, @ date),-1 ))
Go

-- Calculate the number of days in the quarter of a given date

Declare @ date datetime;
Set @ date = getdate ()
-- The number of days between the first day of the current quarter and the first day of the next quarter
Select datediff (day, dateadd (quarter, datediff (quarter, 0, @ date), 0), dateadd (quarter, 1 + datediff (quarter, 0, @ date ), 0 ))
-- Simplify with variables
Select @ date = dateadd (quarter, datediff (quarter, 0, @ date), 0) -- the first day of this quarter
Select datediff (day, @ date, dateadd (quarter, 1, @ date ))
Go