Saturday , December 9 2023

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:


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *