Site icon Database Tutorials

DAY, MONTH and YEAR Functions in SQL Server(TSQL)

 

We can find the day using DAY function, month using MONTH function and  year using YEAR function from a date.

It takes the date() as a parameter and returns a value in the date data type.

Let’s make an example for a better understanding of these functions.

Find the day, month and year of a date:

Exit mobile version