/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 vote178 views1 answer
Start and stop mysql
SQL
0 vote174 views1 answer
Phpmyadmin tabellentyp ändern
SQL
6 votes182 views1 answer
To count number of rows in SQL table
SQL
0 vote196 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
5 votes187 views2 answers
Oracle find all tables with column name
SQL
0 vote134 views1 answer
Import sql file in mysql linux
SQL
1 vote178 views1 answer
Mysql monthname
SQL
0 vote186 views1 answer
Search In the Data using ObjectName
SQL
24 votes194 views6 answers
Rename a column in sql server
SQL
0 vote191 views2 answers
Postgresql change user role grant
SQL