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')
本文共 265 字，大约阅读时间需要 1 分钟。
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')
转载于:https://www.cnblogs.com/0xcafedaddy/p/9371708.html