获得当前时间:
select sysdate from dual;
select systimestamp from dual;
timestamp to date:(隐式转换)
select systimestamp+0 from dual;
特别是表中日期字段类型为timestamp时 获取时间差时特别有用
如:t.birth 为timestamp类型 获取出生到当前有多少天:
select round(to_number(sysdate-(t.birth+0))) from dual;
当然可以先to_char再to_date 但有点麻烦