/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

-1 vote120 views1 answer
Mysql if example
SQL
0 vote135 views1 answer
How to connect postgresql database with java
SQL
3 votes146 views1 answer
Make a field auto_increment mysql
SQL
-1 vote136 views1 answer
Mysql case when multiple conditions
SQL
0 vote172 views1 answer
Sql alter column name sql server
SQL
0 vote108 views1 answer
Mysql collation for all languages
SQL
0 vote141 views1 answer
Find usage of table in sql server
SQL
1 vote160 views1 answer
Mysql not supported auth mode
SQL
5 votes158 views1 answer
Mysql where one year ago
SQL
0 vote166 views1 answer
Compress sql file database ubuntu
SQL