Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: Extract a Value From a Date

Explore how to extract specific values like the year from date fields using SQL date functions. Understand the use of YEAR, SUBSTRING, LEFT, and DATE_FORMAT functions with examples and alternative methods. Gain skills to handle date extraction questions in SQL interviews especially with real table examples.

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 ...