/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 vote134 views1 answer
Unique vs distinct sql
SQL
13 votes193 views3 answers
List all the tables in sql
SQL
3 votes212 views2 answers
Wp do sql query from function
SQL
1 vote184 views1 answer
Sql server kill all connections
SQL
0 vote178 views1 answer
Mysql 8 error on identified by
SQL
0 vote280 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote159 views1 answer
Mysql select last 15 minutes
SQL
0 vote168 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote163 views1 answer
How to find median of a column sql
SQL
0 vote173 views1 answer
Xampp mysql version
SQL