How is the datepart function used in SQL?

9 months ago

Emily Johnson

2 minutes

In SQL, the DATEPART function is used to extract specific parts of a date (such as year, month, day, hour, etc.).

The basic syntax of it is:

DATEPART(datepart, date)

In this case, datepart represents the date portion to be extracted, which can be one of the following commonly used parameters:

The date expression indicates a desire to extract the date portion from it.

For example, to extract the year from a specific date, you can use the following SQL statement:

SELECT DATEPART(year, '2022-01-01') AS Year;

The statement will yield 2022.