mysql中时间格式转成日期格式作比较
具体如下:SUBSTR(create_time,1,10)
SELECT id, product_id, account_id, SUBSTR(create_time,1,10),STATUS FROM ums_footprint
SELECT id, product_id, account_id, create_time,STATUS FROM ums_footprint
具体如下:SUBSTR(create_time,1,10)
SELECT id, product_id, account_id, SUBSTR(create_time,1,10),STATUS FROM ums_footprint
SELECT id, product_id, account_id, create_time,STATUS FROM ums_footprint