select b.*,u.*,d.*,p.* from bill b ,user u,department d,project p where b.openId = u.openId and u.departmentId = d.id and b.projectNo = p.projectNo and str_to_date('2016.05.28','%Y.%m.%d')<b.createTime;
mysql日期比较,注意格式
最新推荐文章于 2024-03-23 07:30:41 发布