SQL Interview Preparation/

...

/

Answer: Extract a Value From a Date

Answer: Extract a Value From a Date

Find a detailed explanation of how to extract the year from a date using an SQL query.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to extract the year from a date */
SELECT *, YEAR(DateOfJoining) AS YearOfJoining
FROM   EmployeeDetails;

Explanation

The explanation of the code solution is given below:

  • Line 2: The SELECT query selects all the columns using * and the calculated column with the date/time function YEAR to find the year. We use AS to set an alias for the column.

  • Line 3: The FROM clause specifies the table name as EmployeeDetails. ...

Recall of relevant concepts