#065 Get specific part of a date in Azure SQL

This T-SQL code uses the DATEPART function to extract information specific to the current date and time, which is obtained by the GETDATE() function. I'll explain each part of the code:

SELECT 
  DATEPART(YEAR, GETDATE()) AS CurrentYear,
  DATEPART(MONTH, GETDATE()) AS CurrentMonth,
  DATEPART(DAY, GETDATE()) AS CurrentDay

1. YEAR, GETDATE()) AS CurrentYear:

   • DATEPART: Function that returns a specific part of a date and time.
   • YEAR: Specifies that the part of the date that will be returned is the year.
   • GETDATE(): Function that returns the current date and time.
   AS CurrentYear
   • : Renames the result to "CurrentYear".

2. DATEPART(MONTH, GETDATE()) AS CurrentMonth

   :
   • MONTH: Specifies that the part of the date that will be returned is the month.
   AS CurrentMonth
   • : Renames the result to "CurrentMonth".

3. DATEPART(DAY, GETDATE()) AS CurrentDay

   :
   • DAY: Specifies that the part of the date that will be returned is the day.
   • ASCurrentDay: Renames the result to "CurrentDay".

code returns three columns: "CurrentYear", "CurrentMonth", and "CurrentDay", which represent, respectively, the year, month, and day of the current date and time. This query is useful when you need to extract specific date and time information in SQL Server.