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

dbtut February 22, 2019 MSSQL, 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:

SELECT DAY('2019-12-16') AS day_of_date,
       MONTH('2019-12-16') AS month_of_date,
       YEAR('2019-12-16') AS year_of_date;

SELECT DAY('2019-12-16') AS day_of_date,

MONTH('2019-12-16') AS month_of_date,

YEAR('2019-12-16') AS year_of_date;

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux