/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 vote189 views1 answer
Print boolean in plsql
SQL
1 vote192 views1 answer
SQL: merging multiple row data in string
SQL
0 vote243 views1 answer
Mysql trigger to delete old data
SQL
0 vote223 views1 answer
Sql select rows with different values in one column
SQL
0 vote228 views1 answer
Plsql check for string in numeric
SQL
1 vote181 views1 answer
Truncate left characters mysql
SQL
3 votes209 views2 answers
Sql not contains
SQL
0 vote236 views1 answer
Delete from table where length sql
SQL
0 vote187 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote145 views2 answers
Jupyter notebook connect to database
SQL