Mungkin kalo detail sampai hari; select fLOOR(months_between(to_date(:as_of_date,'ddmmrrrr'),to_date(:joint_date,'ddmmrrrr'))/12)Jumlah_Tahun, floor(months_between(to_date(:as_of_date,'ddmmrrrr'),to_date(:joint_date,'ddmmrrrr')) -FLOOR(months_between(to_date(:as_of_date,'ddmmrrrr'),to_date(:joint_date,'ddmmrrrr'))/12)*12)Bulan, FLOOR(ROUND(((months_between(to_date(:as_of_date,'ddmmrrrr'),to_date(:joint_date,'ddmmrrrr')) - FLOOR(months_between(to_date(:as_of_date,'ddmmrrrr'),to_date(:joint_date,'ddmmrrrr'))/12)*12) - floor(months_between(to_date(:as_of_date,'ddmmrrrr'),to_date(:joint_date,'ddmmrrrr')) -FLOOR(months_between(to_date(:as_of_date,'ddmmrrrr'),to_date(:joint_date,'ddmmrrrr'))/12)*12)),2) * 30)Hari from dual; :as_of_date -> parameter Tanggal Akhir, misalkan isi sysdate :Joint_date -> parameter tanggal awal misal '11121970' Hasilnya 36 Tahun 2 bulan 1 Hari. Maaf Kalau terlalu membingungkan... Mungkin ada pencerahan dari Tman2 Millist yang lain.. Thx ------ Wahyu Laksono
----- Original Message ---- From: Pandu W Perwira <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, February 13, 2007 5:44:57 PM Subject: Re: [indo-oracle] Tanya:Cara ngitung tahun coba pakai ini , misal struktur tabel anda TABEL1 (TGL_LAHIR char(8)), maka : SELECT FLOOR(MONTHS_ BETWEEN(TRUNC( SYSDATE), TO_DATE(TGL_ LAHIR,'ddmmyyyy' ))/12) AS "UMUR" FROM TABEL1 semoga membantu. Ade Octora <[EMAIL PROTECTED] com> wrote: coba kamu convert dulu jadi Type DATE select TO_DATE ('11121970', 'DDMMYYYY') from dual rasanya sih klo dah dalam Type DATE udah bisa d calculate, semoga bisa membantu. Thanks And Regards, ============ ========= ======= Ade Veria Octora Email : [EMAIL PROTECTED] com ----- Original Message ---- From: Ryant Febrian <pejantan_4u@ yahoo.com> To: indo-oracle@ yahoogroups. com Sent: Tuesday, February 13, 2007 4:54:21 PM Subject: [indo-oracle] Tanya:Cara ngitung tahun Dear All, Saya punya kasus sebagai berikut, saya punya field tanggal dengan format character lalu saya mau hitung tahun dari setiap record tersebut. contoh : field tanggal_lahir 01021889 11121970 13081982 itu field, tipe data character. saya mau menghitung umur masing2 tanggal lahir tersebut. gmn caranya ya ?? Mohon maaf klo agak membingungkan pertanyaan saya, saya jg lagi bingung nie.. ^_^. ____________ _________ _________ _________ _________ _________ _ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail. yahoo.com [Non-text portions of this message have been removed] <!-- #ygrp-mlmsg {font-size:13px; font-family: arial,helvetica, clean,sans- serif;} #ygrp-mlmsg table {font-size:inherit; font:100% ;} #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica, clean,sans- serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height: 1.22em;} #ygrp-text{ font-family: Georgia; } #ygrp-text p{ margin:0 0 1em 0; } #ygrp-tpmsgs{ font-family: Arial; clear:both; } #ygrp-vitnav{ padding-top: 10px; font-family: Verdana; font-size:77% ; margin:0; } #ygrp-vitnav a{ padding:0 1px; } #ygrp-actbar{ clear:both; margin:25px 0; white-space: nowrap; color:#666; text-align:right; } #ygrp-actbar .left{ float:left; white-space: nowrap; } .bld{font-weight: bold;} #ygrp-grft{ font-family: Verdana; font-size:77% ; padding:15px 0; } #ygrp-ft{ font-family: verdana; font-size:77% ; border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom: 10px; } #ygrp-vital{ background-color: #e0ecee; margin-bottom: 20px; padding:2px 0 8px 8px; } #ygrp-vital #vithd{ font-size:77% ; font-family: Verdana; font-weight: bold; color:#333; text-transform: uppercase; } #ygrp-vital ul{ padding:0; margin:2px 0; } #ygrp-vital ul li{ list-style-type: none; clear:both; border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight: bold; color:#ff7900; float:right; width:2em; text-align:right; padding-right: .5em; } #ygrp-vital ul li .cat{ font-weight: bold; } #ygrp-vital a { text-decoration: none; } #ygrp-vital a:hover{ text-decoration: underline; } #ygrp-sponsor #hd{ color:#999; font-size:77% ; } #ygrp-sponsor #ov{ padding:6px 13px; background-color: #e0ecee; margin-bottom: 20px; } #ygrp-sponsor #ov ul{ padding:0 0 0 8px; margin:0; } #ygrp-sponsor #ov li{ list-style-type: square; padding:6px 0; font-size:77% ; } #ygrp-sponsor #ov li a{ text-decoration: none; font-size:130% ; } #ygrp-sponsor #nc { background-color: #eee; margin-bottom: 20px; padding:0 8px; } #ygrp-sponsor .ad{ padding:8px 0; } #ygrp-sponsor .ad #hd1{ font-family: Arial; font-weight: bold; color:#628c2a; font-size:100% ; line-height: 122%; } #ygrp-sponsor .ad a{ text-decoration: none; } #ygrp-sponsor .ad a:hover{ text-decoration: underline; } #ygrp-sponsor .ad p{ margin:0; } o {font-size:0; } .MsoNormal { margin:0 0 0 0; } #ygrp-text tt{ font-size:120% ; } blockquote{margin: 0 0 0 4px;} .replbq {margin:4;} --> ____________ _________ _________ _________ _________ _________ _ Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. http://farechase. yahoo.com/ promo-generic- 14795097 [Non-text portions of this message have been removed] ------------ --------- --------- --- The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. [Non-text portions of this message have been removed] ____________________________________________________________________________________ Never Miss an Email Stay connected with Yahoo! Mail on your mobile. Get started! http://mobile.yahoo.com/services?promote=mail [Non-text portions of this message have been removed]
