操作时间

来源：互联网发布：怎么删除淘宝追加评价编辑：程序博客网时间：2024/05/14 23:53

作者：eygle |English Version 【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2008/04/calculate_datetime.html

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

Session altered.

SQL> select sysdate, sysdate+1/24, sysdate +1/1440, sysdate + 1/86400 from dual;

SYSDATE SYSDATE+1/24 SYSDATE+1/1440 SYSDATE+1/86400
------------------- ------------------- ------------------- -------------------
2008-04-16 21:23:19 2008-04-16 22:23:19 2008-04-16 21:24:19 2008-04-16 21:23:20

SQL> select sysdate,sysdate + 60/(24*60*60) from dual;

SYSDATE SYSDATE+60/(24*60*6
------------------- -------------------
2008-04-16 21:24:40 2008-04-16 21:25:40

Trunc函数只显示日期

SQL> select sysdate,trunc(sysdate) from dual;

SYSDATE SYSDATE+60/(24*60*6
------------------- -------------------
2008-04-16 21:24:40 2008-04-16