与oracle当前时间相关
select to_char(sysdate,'YYYYMMDD HH24:MI:SS') "sysdate",SYSTIMESTAMP,
to_char(current_date,'YYYYMMDD HH24:MI:SS')"currentdate",current_timestamp,
DBTIMEZONE,SESSIONTIMEZONE from dual;
发布时间: 2012-09-24 13:49:41 作者: rapoo
与oracle当前时间相关
select to_char(sysdate,'YYYYMMDD HH24:MI:SS') "sysdate",SYSTIMESTAMP,
to_char(current_date,'YYYYMMDD HH24:MI:SS')"currentdate",current_timestamp,
DBTIMEZONE,SESSIONTIMEZONE from dual;