Thanks Tomi --- In [email protected], Tomi Wijanto <[EMAIL PROTECTED]> wrote: > > udah pernah dibahas di asktom > > http://asktom.oracle.com/pls/ask/f? p=4950:8:18385123809160956094::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERI A: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/
