aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_age_str
Parameters
Name
Type
Mode
birthdate
date
IN
Definition
WITH d AS (SELECT NULLIF(EXTRACT(YEAR FROM age(birthdate)),0) AS years, NULLIF(EXTRACT(MONTH FROM age(birthdate)),0) AS months, EXTRACT(DAY FROM age(birthdate)) AS days ) SELECT COALESCE(years::TEXT||IIF(years > 1, ' years', ' year'), months::TEXT||IIF(months > 1, ' months', ' month'), days::TEXT||IIF(days > 1, ' days', ' day')) FROM d