python 根据生日计算年龄 sqlalchemy根据身份证号计算生日 性别

时间:2021-12-28 12:05:44
import datetime

def calculate_age(birth_s=''):
birth_d = datetime.datetime.strptime(birth_s, "%Y%m%d")
today_d = datetime.datetime.now()
birth_t = birth_d.replace(year=today_d.year)
if today_d > birth_t:
age = today_d.year - birth_d.year
else:
age = today_d.year - birth_d.year - 1 print('出生日期:%s' % birth_d)
print('今年生日:%s' % birth_t)
print('今天日期:%s' % today_d)
print('如果今天日期大于今年生日,今年-出生年=年龄')
print('如果今天日期不大于今年生日,今年-出生年-1=年龄')
print('年龄:%s' % age)
return age if __name__ == '__main__':
print(calculate_age(''))

放入sqlalchemy模型定义中,id_Num是身份证号,其中6-14位是出生日期。

    @property
def age(self):
if len(self.id_Num) > 14:
birth_s = self.id_Num[6:14]
birth_d = datetime.datetime.strptime(birth_s, "%Y%m%d")
today_d = datetime.datetime.now()
birth_t = birth_d.replace(year=today_d.year)
if today_d > birth_t:
age = today_d.year - birth_d.year
else:
age = today_d.year - birth_d.year - 1
else:
age = 0
return age

引申一下,有身份证以后,性别也可以计算出来

@property
def gender(self):
if len(self.IdNum) > 17:
tag = self.IdNum[16:17]
if (int(tag) % 2) == 0:
result = '女'
else:
result = '男'
else:
result = '未知'
return result

加一个excel算性别

=IF(MOD(MID(D4,17,1),2),"男","女")