Here are a few examples of functions that can help you manipulate DATE in different manners. These will comprise most of your daily job routines.
Tag: CONVERT function examples in SQL Srver
SQL Server – Monthly Report – Group by Month
The following example guide you to retrieve a monthly report. As discussed earlier, If the date column is SMALLDATETIME or DATETIME, we can split it
SQL Server – Daily Report – Group by Date
Like hourly report, the following example guide you to retrieve a daily report. As discussed earlier, If the date column is SMALLDATETIME or DATETIME, we
SQL Server – Hourly Report – Group by Hour
Often it is important to know how many inserts occur per hour in a transaction table OR how many payments are made per hour OR
Big Data & SQL 