/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 vote226 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote230 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote225 views1 answer
Sql put two columns into one
SQL
0 vote266 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote210 views1 answer
GROUP BY postgres
SQL
0 vote208 views1 answer
Postgres sequence name
SQL
5 votes251 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
2 votes204 views2 answers
Select multiple tables mysql
SQL
0 vote197 views1 answer
Compare subqueries oracle
SQL
0 vote189 views1 answer
Sql random decimal
SQL