1,Python
pd.to_datetime()
df['repay_date'] = pd.to_datetime(df['repay_date'], format='%Y-%m-%d') # 将读取的日期转为datatime格式
2,Sql
data_format()
date_format(created_at, '%Y-%m-%d') >= date_format((current_date - INTERVAL '31' DAY), '%Y-%m-%d')
1,Python
df['repay_date'] = pd.to_datetime(df['repay_date'], format='%Y-%m-%d') # 将读取的日期转为datatime格式
2,Sql
date_format(created_at, '%Y-%m-%d') >= date_format((current_date - INTERVAL '31' DAY), '%Y-%m-%d')