/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

0 vote144 views1 answer
Postgres list users and roles
SQL
0 vote127 views1 answer
Sql stored procedure update if parameter is not null
SQL
18 votes105 views3 answers
Mysql query add column with default string value
SQL
0 vote118 views2 answers
Postgresql get last day of month
SQL
0 vote112 views1 answer
Pgsql is not permitted to log in
SQL
0 vote125 views1 answer
Postgresql print sessions using the database
SQL
0 vote127 views1 answer
Template MySQL Zabbix agent
SQL
1 vote112 views1 answer
Data type and their numeric form
SQL
0 vote127 views1 answer
EnvironmentError: mysql_config not found
SQL
44 votes228 views4 answers
Mysql alter table add column first
SQL