/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

8 votes274 views1 answer
Show mysql user table
SQL
0 vote279 views1 answer
Like date sql server not working
SQL
1 vote264 views1 answer
Mysql limit results to 10
SQL
1 vote299 views1 answer
Sql count value greater than
SQL
0 vote283 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote302 views1 answer
Prisma transaction
SQL
0 vote263 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote268 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
5 votes333 views3 answers
Create function in postgresql
SQL
5 votes282 views4 answers
Change auto increment mysql
SQL