1. 数据库是时间戳的时候的处理
select left(create_time,8),create_time,From_unixtime(create_time/1000,'%Y-%m-%d') from task WHERE create_time< 1645545600000 and create_time>1645459200000;
From_unixtime(create_time/1000,'%Y-%m-%d')---记得除1000
1. 数据库是时间戳的时候的处理
select left(create_time,8),create_time,From_unixtime(create_time/1000,'%Y-%m-%d') from task WHERE create_time< 1645545600000 and create_time>1645459200000;
From_unixtime(create_time/1000,'%Y-%m-%d')---记得除1000