Breaking News: Grepper is joining You.com. Read the official announcement!

postgresql calculate age from birthdate

YooPita answered on August 9, 2021 Popularity 9/10 Helpfulness 10/10

answer postgresql calculate age from birthdate

postgresql calculate age from birthdate

Comment

SELECT EXTRACT(YEAR from AGE(NOW(), birth)) as "age", * FROM customers;

Popularity 9/10 Helpfulness 10/10 Language sql

Source: bloomlab.blogspot.com

Tags: postgresql sql

Link to this answer
Share Copy Link

Contributed on Mar 18 2022

YooPita

0 Answers Avg Quality 2/10

Closely Related Answers

calculate age in sql postgresql

Comment

#THIS WORKS FOR POSTGRES and MYSQL
# You can use the AGE function. The AGE function requires two arguementS.
# AGE(late date, early date). The NOW() function returns the current timestamp.

AGE(NOW(), date_of_birth) AS age

#Since NOW() is a timestamp, the result will be like this:
# 45 years 2 months 15 days 21:43:05.378372
#You can then use this to extract the age.

LEFT(age, STRPOS(age,' '))

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: postgresql p

Link to this answer
Share Copy Link

Contributed on Aug 09 2021

Kwams

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

postgresql calculate age from birthdate

Contents

More Related Answers

postgresql calculate age from birthdate

Closely Related Answers

calculate age in sql postgresql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.