/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 vote252 views1 answer
Now() -1 mysql
SQL
-2 votes304 views1 answer
No module named '_sqlite3
SQL
0 vote279 views1 answer
How to increase the width of the screen in oracle
SQL
32 votes318 views6 answers
Insert select
SQL
0 vote303 views2 answers
Import .sql into postgres db command
SQL
0 vote307 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote293 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote296 views1 answer
Mssql now diff 90 day
SQL
2 votes279 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote293 views3 answers
Sql select only time from datetime
SQL