SYSDATE ,TRUNC

SELECT SYSDATE ,TRUNC(SYSDATE),TRUNC(SYSDATE -1),SYSDATE-1/24 FROM DUAL;
2020/11/17 10:58:06 2020/11/17 2020/11/16 2020/11/17 9:58:06

posted @ 2020-11-17 11:01  rjm123456  阅读(75)  评论(0)  编辑  收藏  举报