These functions return the datepart as an integer. Here’s an example of how they work: DECLARE datetime2 = ' AS AS AS YEAR Yes, T-SQL has functions built specifically for the purpose of returning these three dateparts. The most obvious way to return the day, month and year from a date is to use the T-SQL functions of the same name. In particular, the following functions allow you to return the day, month, and year from a date in SQL Server. Either way, there are plenty of ways to do this in SQL Server. Other times we might want the day of the week. For example, sometimes we only want the year, or the month. One of the more common tasks when working with dates is to extract the different parts of the date. Transact-SQL includes a bunch of functions that help us work with dates and times.
