SYSDATE 系统当前日期
itkaifang@SYS> SELECT SYSDATE FROM dual; SYSDATE --------- 12-MAR-17 itkaifang@SYS>
系统默认日期格式为:DD-MON-RR,可修改为便于查看的年月日显示
itkaifang@SYS> alter session set nls_date_format='yyyy-mm-dd h h24:mi:ss'; Session altered. itkaifang@SYS> SELECT SYSDATE FROM dual; SYSDATE ------------------- 2017-03-12 11:55:22
修改回原显示方法相同
itkaifang@SYS> alter session set nls_date_format='DD-MON-RR'; Session altered. itkaifang@SYS> select sysdate from dual; SYSDATE --------- 12-MAR-17 itkaifang@SYS>
SYSTIMESTAMP 包括时区、毫秒的日期格式
itkaifang@SYS> SELECT SYSTIMESTAMP FROM dual; SYSTIMESTAMP --------------------------------------- 12-MAR-17 12.09.15.599468 PM +08:00 itkaifang@SYS>