Stupid Postgres Tricks

I was curious, how many day’s old am I? I suppose I could solve this in many different programming languages, but thought “PG has really good date management features, let me try that”. So here it is.

Calculate how many days old people are

select * from (VALUES
	(CURRENT_DATE - '1976/12/18'::date, 'Jill'),
	(CURRENT_DATE - '1980/06/29'::date, 'Jack'),
	(CURRENT_DATE - '2004/06/03'::date, 'Humpty'),
	(CURRENT_DATE - '2006/06/26'::date, 'Cole'),
	(CURRENT_DATE - '2007/11/02'::date, 'Hubbard'),
	(CURRENT_DATE - '2010/09/24'::date, 'Mary')
	) as bday(days_old_today, person);