/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 votes146 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote140 views1 answer
Create table database in psql
SQL
0 vote173 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote138 views1 answer
Mariadb cast null to 0
SQL
2 votes146 views1 answer
Apex execute batch job
SQL
5 votes144 views1 answer
Mysql where one year ago
SQL
0 vote143 views1 answer
Get the previous column of a table in mysql
SQL
-2 votes145 views1 answer
Modify column name in tsql
SQL
0 vote134 views1 answer
Exclude last comma separated string mysql
SQL
0 vote137 views1 answer
Phpmyadmin tabellentyp ändern
SQL