-- 距19570101天数 select to_days(now())-to_days('19570101'); -- 根据天数反推日期 select date_format(date_add('19570101', INTERVAL to_days(now())-to_days('19570101') day), '%Y%m%d');