To return day, month and year of the date we can use
YEAR function by passing the current date. Similarly, to get day, month and year of other date simply pass other date as parameter to these functions.
SELECT DAY(GETDATE()) as Day, MONTH(GETDATE()) as Month, YEAR(GETDATE()) As Year
Views: 2724 | Post Order: 73