Calculate age by birthdate with SQL
Simple snippet for calculating age by birthdate with SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
SELECT
id,
firstname,
lastname,
date_of_birth,
EXTRACT(YEAR FROM age(users.date_of_birth::DATE)) AS age
FROM users;
/*
id |firstname |lastname |date_of_birth |age
-----------------------------------------------------
24 |"Max" |"Mustermann" |"1987-08-12" |25
51 |"John" |"Doe" |"1985-02-03" |28
*/
X
Url: http://sklueh.de/2013/03/alter-uber-geburtsdatum-mit-postgresql-ermitteln/
Language: SQL | User: sklueh | Created: Sep 24, 2013 | Tags: sql birthdate