如果要获取分钟以前的,可以直接用trunc,比如:
1
SELECT Trunc(systimestamp,'mi') FROM dual;
1
SELECT Trunc(systimestamp) FROM dual;
如果要获取带秒的,trunc就不会写了,
好像就只能通过字符转换了:
1
SELECT To_Date(To_Char(systimestamp,'yyyymmddhh24miss'),'yyyymmddhh24miss') aa FROM dual;
温馨提示:答案为网友推荐,仅供参考