/SQL/How to calculate the age from date of birth in python

How to calculate the age from date of birth in python

Python calculate age from date of birth

from datetime import date

def calculate_age(born):
    today = date.today()
    return today.year - born.year - ((today.month, today.day) < (born.month, born.day))

Source: stackoverflow.com

How to find current age from date of birth in python

today_date = datetime.datetime.now()
dob = datetime.datetime(1982, 5, 20)
print(today_date - dob)

How to calculate the age from date of birth in python

SELECT DATEDIFF (
	year, DOB, getdate()) + CASE 
      WHEN (DATEADD(year,DATEDIFF(year, DOB, getdate()) , DOB) > getdate())
      THEN - 1 
      ELSE 0
END
)

Source: stackoverflow.com

How to calculate the age from date of birth in python

SELECT CASE WHEN dateadd(year, datediff (year, DOB, getdate()), DOB) > getdate()
            THEN datediff(year, DOB, getdate()) - 1
            ELSE datediff(year, DOB, getdate())
       END as Age
FROM <table>

Source: stackoverflow.com

Similar codes

1 vote268 views1 answer
Oracle datafile max size 32gb
SQL
0 vote267 views1 answer
How to fetch unique records from two tables
SQL
0 vote261 views1 answer
Sql server remove enter from string
SQL
0 vote259 views1 answer
Drop domain postgresql
SQL
1 vote260 views1 answer
Oracle add proxy
SQL
5 votes267 views1 answer
Oracle get foreign keys on table
SQL
0 vote278 views1 answer
Mysql remove last character
SQL
9 votes266 views1 answer
Sql server get utc date
SQL
8 votes279 views2 answers
Mysql get first x characters
SQL
0 vote252 views1 answer
Mysql:5.6 syntax create table
SQL