In order to Get age from birthday in postgresql we use AGE() function. AGE() Function in postgresql calculates difference between birth date and current date . Let’s see how to
Get Age from Birthday in postgresql using AGE() function.
We will be using Student_detail table.
Get Age from birthday in Postgresql
Age function gets the difference between birthday and current date.
select *,age(CURRENT_DATE,date(birthdaytime)) as age from student_detail
so the resultant age will be in years months and days as shown below
With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.
