SELECT TRUNC(sysdate, 'dd'),TRUNC(sysdate, 'mm') FROM dual
SELECT to_date( TRUNC(sysdate) - to_char(TRUNC(sysdate), 'D')+ 1) FROM dual;
select TRUNC(sysdate) - to_char(TRUNC(sysdate), 'D') from dual;
select TRUNC(sysdate), to_char(TRUNC(sysdate), 'D') from dual;
关于oracle的日期计算
最新推荐文章于 2023-03-24 08:57:43 发布