udah pernah dibahas di asktom http://asktom.oracle.com/pls/ask/f?p=4950:8:18385123809160956094::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:96012348060
Misalkan tabel tab1 punya kolom col1 bertipe DATE.. select months_between( sysdate, col1 ), trunc( months_between( sysdate, col1 ) /12 ) Years, mod( trunc( months_between( sysdate, col1 ) ), 12 ) months, sysdate - add_months(col1,trunc( months_between( sysdate, col1 ) )) days from tab1; Kalau nilai dari col1 lebih besar dari sysdate, otomatis hasilnya negatif. regards, tomi --- arvind_thomson <[EMAIL PROTECTED]> wrote: > Hi All, > > Please find the total year, month and days from the > diffrence between > system date and hiredate in emp table. > > response me as soon as possible. > > > thanks & regards, > arvind __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
