SELECT UNIX_TIMESTAMP(DATE_SUB(DATE_ADD(last_day(curdate()), INTERVAL 1 DAY),INTERVAL 1 SECOND))* 1000;
select UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL - DAY(CURDATE()) + 1 DAY)) * 1000;
select UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE));
select date_format(now(), '%Y-%m-%d');
select unix_timestamp(now());
select unix_timestamp(now())*1000;
select from_unixtime(1591235360);
select from_unixtime(1591235360,'%Y-%m-%d');
select str_to_date('2020-01-01', '%Y-%m-%d');
select unix_timestamp('2020-01-01');
SELECT year(str_to_date('2020-01-01','%Y-%m-%d'));