今日日期不含时分秒毫秒数(如:2020-10-22 00:00:00):
select (trunc(sysdate)-to_date('1970-01-01 08:00:00','yyyy-mm-dd hh24:mi:ss'))*24*60*60*1000 from dual;
以上sql查询结果是:
1603296000000
获取当年第一天的毫秒数(如:2020-01-01 00:00:00)
select (trunc(sysdate,'yyyy')-to_date('1970-01-01 08:00:00','yyyy-mm-dd hh24:mi:ss'))*24*60*60*1000 from dual;
以上sql查询结果是:
1577808000000
通过java代码验证1577808000000是否为2020-01-01 00:00:00