![SQL SERVER 2012 – Get Day, Month and Year separately from Date Time Using Format Function | SQL Server Portal SQL SERVER 2012 – Get Day, Month and Year separately from Date Time Using Format Function | SQL Server Portal](https://raresql.files.wordpress.com/2013/04/getdaymonthyear.png)
SQL SERVER 2012 – Get Day, Month and Year separately from Date Time Using Format Function | SQL Server Portal
![SQL Server 2022 – TSQL – How to get previous, current and last year dates using DATETRUNC() function | SQL Server Portal SQL Server 2022 – TSQL – How to get previous, current and last year dates using DATETRUNC() function | SQL Server Portal](https://raresql.files.wordpress.com/2022/12/firstdate.png)
SQL Server 2022 – TSQL – How to get previous, current and last year dates using DATETRUNC() function | SQL Server Portal
![SQL Server: Get Week Start Date & Week End Date Using Sql Query - TechNet Articles - United States (English) - TechNet Wiki SQL Server: Get Week Start Date & Week End Date Using Sql Query - TechNet Articles - United States (English) - TechNet Wiki](https://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x0/__key/communityserver-wikis-components-files/00-00-00-00-05/417641.2.png)
SQL Server: Get Week Start Date & Week End Date Using Sql Query - TechNet Articles - United States (English) - TechNet Wiki
![SQL SERVER - Simple Method to Find FIRST and LAST Day of Current Date - SQL Authority with Pinal Dave SQL SERVER - Simple Method to Find FIRST and LAST Day of Current Date - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/d/date_result.png)