django & mysql, queyry使用datetime没有结果
有一个django项目中需要根据日期来查询，在本地调试时没问题，可线上就查询不到结果:
now = datetime.datetime.now()
cashin = Cashin.objects.filter(update_time__month=now.month)
数据库用的是mysql，打印原始sql语句:
print Cashin.objects.filter(update_time__month=now.month)
#SELECT `cash_cashin`.`id`, `cash_cashin`.`create_time`, `cash_cashin`.`update_time`, `cash_cashin`.`status`, `cash_cashin`.`source`, `cash_cashin`.`order_id`, `cash_cashin`.`partner_order_id`, `cash_cashin`.`other`, `cash_cashin`.`desc`, `cash_cashin`.`money` FROM `cash_cashin` WHERE EXTRACT(MONTH FROM ...Continue reading