SELECT to_date('19700101','yyyymmdd') + (TIMESTAMP_VALUE/1000/24/60/60) AS date_time FROM TABLENAME;
月份：2021年2月
解决idea环境代码保存后不能实时编译的问题
1.在项目目录下运行 mvn idea:idea
2. cd yourporject/path, rm *.iml *.ipr *.iws, the reopen idea, 重新在idea中执行maven build
3. Alt+shift+A, Type:Registry 选择 compiler.automake.allow.when.app.running 打勾