Answers for "get number of days in month in sql"

sql get number of days between two dates

DATEDIFF(DAY, '1/1/2011', '3/1/2011')

Posted by: Guest on September-22-2020

count number of entires by months sql

select month(DepotArrivalDate), count(*)
from tbl_CMS_Container
WHERE     year(DepotArrivalDate) = '2013' 
group by month(DepotArrivalDate)

Posted by: Guest on August-07-2021

Code answers related to "get number of days in month in sql"