/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

4 votes202 views2 answers
Convert utc to est sql
SQL
0 vote170 views1 answer
Query for backup a database at another location in file system
SQL
0 vote193 views1 answer
Count column of tables psql
SQL
4 votes158 views2 answers
Postgresql default value
SQL
0 vote178 views4 answers
Convert databse to achieve log mode oracle
SQL
5 votes158 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote145 views1 answer
Oracle last character of string
SQL
0 vote153 views1 answer
How to check replication lag in mySQL
SQL
0 vote114 views1 answer
Expose db in virtualbox
SQL
5 votes153 views1 answer
Oracle get nls settings
SQL