Günleri birer birer arttırmak için aşağıdaki kod güzel bir yöntem
SET SERVEROUTPUT ON
DECLARE
test_date DATE;
BEGIN
test_date := TO_DATE ('28-mar-2009', 'dd-mon-yyyy');
FOR a IN 1 .. 5
LOOP
DBMS_OUTPUT.put_line ( TO_CHAR (test_date, 'dd-Mon-yyyy') );
test_date := test_date + 1;
END LOOP;
END;
/
28-Mar-2009
29-Mar-2009
30-Mar-2009
31-Mar-2009
01-Nis-2009
PL/SQL procedure successfully completed.
şu şekilde de kullanabiliriz.
select to_char(to_date('20080101','yyyymmdd')+50) into test_date from dual;
SET SERVEROUTPUT ON
DECLARE
test_date DATE;
BEGIN
test_date := TO_DATE ('28-mar-2009', 'dd-mon-yyyy');
FOR a IN 1 .. 5
LOOP
DBMS_OUTPUT.put_line ( TO_CHAR (test_date, 'dd-Mon-yyyy') );
test_date := test_date + 1;
END LOOP;
END;
/
28-Mar-2009
29-Mar-2009
30-Mar-2009
31-Mar-2009
01-Nis-2009
PL/SQL procedure successfully completed.
şu şekilde de kullanabiliriz.
select to_char(to_date('20080101','yyyymmdd')+50) into test_date from dual;
No comments:
Post a Comment