-
Start of month from date in MS SQL (opposite to EOMONTH function)
Sometimes we need to select values grouped by month from MS SQL Table. Probably the easiest way to do it is to call function DateAdd with DateDiff: SELECT Sum(YourColumn), DATEADD(month, DATEDIFF(month, 0, [YourDateColumn]), 0) as 'Date' FROM YourTable GROUP BY DATEADD(month, DATEDIFF(month, 0, [YourDateColumn]), 0); Or we can use EOMONTH function that give us date that is…
Loading posts...