건

두 날짜의 차이를 년월일 시분초로 표현하기

· 2008-04-22 (화) 02:13:30 · 5221
-- 년월일
DECLARE
        d1 DATE;
        d2 DATE;
        years NUMBER;
        months  NUMBER;
        days    NUMBER;
BEGIN
        d1 := to_date( '09-JUL-2007', 'DD-MON-YYYY' );
        d2 := to_date( '24-JUL-1995', 'DD-MON-YYYY' );

        years := trunc( months_between( d1, d2 ) / 12 );
        months := mod( trunc( months_between( d1, d2 ) ), 12 );
        days := d1 - add_months(d2,trunc( months_between( d1, d2 ) ));

        dbms_output.put_line( 'years = ' || years);
        dbms_output.put_line( 'months = ' || months);
        dbms_output.put_line( 'days = ' || days);
END;
/


<결과>
years = 11
months = 11
days = 15




-- 년월일시분초
DECLARE
        d1 DATE;
        d2 DATE;
        years NUMBER;
        months  NUMBER;
        days    NUMBER;
        hours NUMBER;
        minutes NUMBER;
        seconds NUMBER;
       
BEGIN
        d1 := to_date( '09-JUL-2007 23:10:43', 'DD-MON-YYYY HH24:MI:SS' );
        d2 := to_date( '24-JUL-1995 10:09:40', 'DD-MON-YYYY HH24:MI:SS' );

        years := trunc( months_between( d1, d2 ) / 12 );
        months := mod( trunc( months_between( d1, d2 ) ), 12 );
        days := trunc(d1 - add_months(d2,trunc( months_between( d1, d2 ) )));
        hours := trunc( mod( (d1-d2)*24, 24 ) );
        minutes := trunc( mod( (d1-d2)*24*60, 60 ) );
        seconds := trunc( mod( (d1-d2)*24*60*60, 60 ) );

        dbms_output.put_line( 'years = ' || years);
        dbms_output.put_line( 'months = ' || months);
        dbms_output.put_line( 'days = ' || days);
        dbms_output.put_line( 'hours = ' || hours);
        dbms_output.put_line( 'minutes = ' || minutes);
        dbms_output.put_line( 'seconds = ' || seconds);
       
END;
/


<결과>
years = 11
months = 11
days = 15
hours = 13
minutes = 1
seconds = 3
[이 게시물은 관리자님에 의해 2011-10-31 16:47:36 Oracle에서 이동 됨]
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
08-06-15 조회 3,213
08-06-15 조회 2,438
08-06-14 조회 2,775
08-06-14 조회 3,678
08-06-14 조회 3,366
08-06-12 조회 2,241
08-06-11 조회 2,288
08-06-11 조회 2,380
08-06-11 조회 7,408
08-06-11 조회 7,139
08-06-08 조회 3,311
08-06-07 조회 2,247
08-06-05 조회 2,375
08-06-05 조회 3,344
08-06-05 조회 2,715
08-06-05 조회 2,368
08-06-05 조회 2,390
08-06-04 조회 2,315
08-06-03 조회 2,307
08-06-03 조회 5,382
08-06-03 조회 3,614
08-06-02 조회 2,907
08-06-02 조회 4,055
08-06-01 조회 2,667
08-05-31 조회 2,367
08-05-31 조회 2,379
08-05-31 조회 2,466
08-05-30 조회 2,336
08-05-29 조회 2,487
08-05-29 조회 3,757
08-05-27 조회 5,586
08-05-26 조회 2,433
08-05-26 조회 5,339
08-05-25 조회 5,430
08-05-24 조회 2,493
08-05-23 조회 3,502
08-05-23 조회 2,919
08-05-23 조회 4,669
08-05-22 조회 2,675
08-05-21 조회 5,013
08-05-21 조회 4,799
08-05-21 조회 3,945
08-05-20 조회 4,548
08-05-20 조회 4,124
08-05-20 조회 3,346
08-05-20 조회 4,625
08-05-20 조회 3,966
08-05-20 조회 4,852
08-05-19 조회 2,399
08-05-16 조회 3,529
08-05-15 조회 2,592
08-05-15 조회 2,416
08-05-15 조회 2,406
08-05-14 조회 2,349
08-05-13 조회 2,808
08-05-13 조회 4,211
08-05-13 조회 4,625
08-05-09 조회 4,395
08-05-08 조회 3,154
08-05-08 조회 5,308
08-05-08 조회 2,656
08-05-07 조회 2,360
08-05-07 조회 2,507
08-05-07 조회 2,312
08-05-01 조회 2,627
08-05-01 조회 2,976
08-04-29 조회 3,821
08-04-28 조회 3,646
08-04-26 조회 2,668
08-04-26 조회 2,418
08-04-26 조회 3,693
08-04-25 조회 4,119
08-04-23 조회 4,554
08-04-22 조회 4,515
08-04-22 조회 3,648
08-04-22 조회 5,222
08-04-22 조회 4,597
08-04-22 조회 6,985
08-04-22 조회 4,036
08-04-21 조회 3,186
08-04-21 조회 3,232
08-04-21 조회 3,169
08-04-21 조회 2,996
08-04-21 조회 4,093
08-04-20 조회 3,266
08-04-20 조회 2,942
08-04-20 조회 3,468
08-04-19 조회 2,377
08-04-18 조회 3,087
08-04-18 조회 4,420
08-04-17 조회 3,659
08-04-17 조회 3,120
08-04-17 조회 3,324
08-04-17 조회 2,611
08-04-17 조회 3,008
08-04-17 조회 2,494
08-04-17 조회 3,045
08-04-17 조회 3,108
08-04-17 조회 2,298
08-04-17 조회 4,583