search

Jacobvu84 / sql-basic-advance

SQL
0 stars 0 forks source link

Date Diff #3

Open Jacobvu84 opened 9 months ago

Jacobvu84 commented 9 months ago

Detail here and docs 

SELECT
  CONCAT(first_name, ' ', last_name) AS full_name,
  birth_date,
  FLOOR(DATEDIFF(CURRENT_DATE, birth_date) / 365) AS age
FROM employees;

from here

Jacobvu84 commented 9 months ago 
SELECT
  CONCAT(first_name, ' ', last_name) AS full_name,
  employment_date,
  PERIOD_DIFF
    (
    EXTRACT(YEAR_MONTH FROM CURRENT_DATE), 
    EXTRACT(YEAR_MONTH FROM employment_date)
    ) 
      AS months_diff
FROM employees;