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]> 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]
----- Original Message ----
From: Ryant Febrian <[EMAIL PROTECTED]>
To: [email protected]
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]
