Learn about some of the most common and useful SQL functions for manipulating date and time data, such as extracting, formatting, converting, and calculating. Skip to main content LinkedIn Articles ...

Este comando permite selecioanr datas . SELECT SalesOrderID, DATEPART(MONTH,OrderDate) AS MES FROM Sales.SalesOrderHeader PODE SE SELECIONAR TAMBÉM O DIA (DAY) E O ANO (YEAR) SELECT AVG (TotalValue) ...