![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 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/getdaymonthyear1-2.png?w=584)
SQL SERVER 2012 – Get Day, Month and Year separately from Date Time Using Format Function | SQL Server Portal
![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/wp-content/uploads/2018/09/flmonth.png)
SQL SERVER - Simple Method to Find FIRST and LAST Day of Current Date - SQL Authority with Pinal Dave
![SQL SERVER - List the Name of the Months Between Date Ranges - Part 2 - SQL Authority with Pinal Dave SQL SERVER - List the Name of the Months Between Date Ranges - Part 2 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/betweendaysmonth.jpg)
SQL SERVER - List the Name of the Months Between Date Ranges - Part 2 - SQL Authority with Pinal Dave
![SQL Server query to get total against each month of a year and return the year and month in date format not the string format - Stack Overflow SQL Server query to get total against each month of a year and return the year and month in date format not the string format - Stack Overflow](https://i.stack.imgur.com/xwtr2.png)
SQL Server query to get total against each month of a year and return the year and month in date format not the string format - Stack Overflow
![sql server - SQL query to get data till current date(considering month and date) for the particular year - Stack Overflow sql server - SQL query to get data till current date(considering month and date) for the particular year - Stack Overflow](https://i.stack.imgur.com/Sy2wm.png)