Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: The DATE Column and Calculations

Explore how to calculate age and manipulate date columns in SQL using TIMESTAMPDIFF and related date functions. Understand aliases, selective columns, and alternate methods for date calculations to apply in interview problems.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to calculate age of an employee */
SELECT *, FLOOR(TIMESTAMPDIFF(DAY, DateOfBirth, NOW()) / 365) AS Age
FROM   Employees;

Explanation

The explanation of the solution code is given below:

  • Line 2: The SELECT query selects all the columns using * and the calculated column for age. The TIMESTAMPDIFF() function takes three variables, the unit of time (e.g., YEAR, MONTH, DAY), and two datetime expressions. It calculates the difference between the datetime expressions in the specified unit. The ...