/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 vote191 views1 answer
Oracle grant select on schema
SQL
5 votes150 views2 answers
Postgre insert select
SQL
0 vote157 views1 answer
Get current date data in mysql
SQL
4 votes151 views2 answers
Select first and last row mysql
SQL
3 votes205 views2 answers
How to View column names of a table in SQL
SQL
0 vote158 views1 answer
SQL isnumeric DB2
SQL
0 vote162 views2 answers
How covert into int in maria db
SQL
0 vote158 views3 answers
Mysql delete if not in another table
SQL
0 vote157 views1 answer
Calculate age in sql
SQL
3 votes154 views2 answers
Update Query in SQL Server
SQL