Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...
DATE_SUB - Subtracts a time/date interval from a date and then returns the date DAY - Returns the day of the month for a given date DAYNAME - Returns the weekday name for a given date DAYOFMONTH - ...
AVG: Returns the average value of a numeric column. COUNT: Returns the number of rows that match a specified condition. MAX: Returns the maximum value in a set of values. MIN: Returns the minimum ...