/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 vote152 views1 answer
Login failed for user sql server
SQL
0 vote123 views1 answer
Sql server port 1434
SQL
0 vote139 views1 answer
Month mysql
SQL
8 votes169 views6 answers
Insert command in sql
SQL
0 vote132 views1 answer
Sqlalchemy one column of two has to be not null
SQL
1 vote139 views2 answers
Check if word is in column sql
SQL
31 votes120 views1 answer
Postgresql add column with constraint
SQL
0 vote120 views1 answer
Sql get month from date
SQL
1 vote176 views1 answer
Python clean sql string
SQL
0 vote167 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL