/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

2 votes258 views1 answer
How to insert string variable into sqlite database
SQL
0 vote282 views1 answer
Sql: extract day text from datetime value
SQL
0 vote285 views1 answer
T-sql update table variale
SQL
0 vote290 views10 answers
Sql statement checker corrector
SQL
-1 vote258 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote252 views1 answer
Mysql count by month
SQL
1 vote256 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote280 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote277 views1 answer
Call object contructor and call methods of object
SQL
1 vote265 views1 answer
Declare table variable
SQL