/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

2 votes200 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
3 votes176 views1 answer
Oracle transaction commit rollback example
SQL
12 votes312 views2 answers
Find duplicates mysql column
SQL
18 votes174 views3 answers
Mysql add column with default value
SQL
0 vote179 views1 answer
Set a default value for a column in sqlite
SQL
3 votes183 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote179 views1 answer
Mysql_num_fields in mysqli
SQL
8 votes167 views3 answers
Duplicate entry
SQL
2 votes168 views1 answer
Sql server find table name
SQL
0 vote183 views1 answer
Flush user resource mysql
SQL