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

postgresql age in minutes

GutoTrosla answered on August 9, 2021 Popularity 6/10 Helpfulness 6/10

answer postgresql age in minutes

postgresql age in minutes

Comment

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

Popularity 6/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

Closely Related Answers

age postgres

Comment

#Code language: SQL (Structured Query Language) (sql)
SELECT age(CAST (day_of_birth AS timestamp)) AS Age;
--0 years 0 months 0 days
SELECT (CURRENT_DATE - CAST(day_of_birth AS date))/365 age;
--0 (age_in_years)

Popularity 9/10 Helpfulness 6/10 Language sql

Source: www.postgresqltutorial.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Nov 03 2021

JoeCoder

0 Answers Avg Quality 2/10

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

postgresql age in minutes

Contents

More Related Answers

postgresql age in minutes

Closely Related Answers

age postgres

calculate age in sql postgresql

Grepper

Documentation

Social

Legal

Contact

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