Text copied!
DATEPART function
In SQL, DATEPART function is used to extract the specific part from a given date and time such as year, month, day and hour etc.
The syntax of the DATEPART function generally looks like this :
DATEPART(datepart, date)
• Specify the 'datepart' of the date or time value that you want to extract. i.e. year, month, day etc.
• Specify the 'date or time value' or 'column' from which you want to extract the specified part.
Here's an example of how you might use the DATEPART function :
1. Let's assume we have a table named "[Employees]".
2. Let's assume you want to extract 'Year' from the Joining_Date column.
3. Run below SQL statement :
SELECT *, DATEPART(YEAR, Joining_Date) AS Joining_Year
FROM [Employees];
4. In above statement, DATEPART function extracts 'Year' from Joining_Date column and returns it as an integer value in a column named 'Joining_Year'.
Remember :
Using this function in a select statement won't modify the [Employees] table directly, but it will only be reflected in the select statement's output.