Oracle關於時間/日期的操作
當前時間減去
select sysdate
當前時間減去
select sysdate
當前時間減去
select sysdate
當前時間減去
select sysdate
當前時間減去
select sysdate
時間間隔乘以一個數字
select sysdate
select sysdate
select sysdate
select sysdate
select sysdate
參考oracle的相關關文檔(ORACLE
select to_date(
具體用法和上面的to_char差不多
select trunc(sysdate
select trunc(sysdate ) from dual
select to_char(trunc(sysdate
select to_char(current_timestamp(
select to_char(current_timestamp(
declare
type rc is ref cursor;
l_rc rc;
l_dummy all_objects
l_start number default dbms_utility
begin
for I in
loop
open l_rc for
fetch l_rc into l_dummy;
From:http://tw.wingwit.com/Article/program/Oracle/201311/17649.html