mysql格式化日期

select from_unixtime(time_created/1000, '%Y%m%d %H:%i:%S') as time from dual

select * from table_name where billing_date/1000 >=unix_timestamp('2018-06-01') and billing_date/1000 <= unix_timestamp('2018-06-30')