repeating-sql/select-from-invoice-7.6.sql at main · Bujhm/repeating-sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
/*
Created by: Ihor Semeniuk
Create Date: 09/12/2023
Decscription: Calculate the ages of all employees
*/
SELECT
	FirstName,
    LastName,
    BirthDate,
    STRFTIME('%Y-%m-%d', BirthDate) AS [Birth Date No Timecode],
    STRFTIME('%Y-%m-%d', 'now') - STRFTIME('%Y-%m-%d', BirthDate) AS Age
FROM
	Employee