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

calculate age in sql postgresql

Kwams answered on August 9, 2021 Popularity 9/10 Helpfulness 5/10

answer calculate age in sql postgresql

related postgresql calculate age from birthdate

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 sql

Link to this answer
Share Copy Link

Contributed on Aug 09 2021

Kwams

0 Answers Avg Quality 2/10

Closely Related Answers

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 p

Link to this answer
Share Copy Link

Contributed on Mar 18 2022

YooPita

0 Answers Avg Quality 2/10

postgresql age in minutes

Comment

select EXTRACT(EPOCH FROM (_end - _init))/60

Popularity 5/10 Helpfulness 6/10 Language sql

Source: learnsql.com

Tags: minutes postgresql sql

Link to this answer
Share Copy Link

Contributed on Dec 08 2023

GutoTrosla

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.

calculate age in sql postgresql

Contents

More Related Answers

calculate age in sql postgresql

Closely Related Answers

postgresql calculate age from birthdate

postgresql age in minutes

Grepper

Documentation

Social

Legal

Contact

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