glufke.net

TO_CHAR(ppf.date_of_birth,'Day DD "de" FMMonth','NLS_DATE_LANGUAGE = spanish') CUMPLEANO,
TRUNC( (SYSDATE-ppf.start_date) /365) ANO,
TRUNC(((SYSDATE-ppf.start_date) - ( TRUNC( (SYSDATE-ppf.start_date) /365) * 365) )/30) mês,
TRUNC(((SYSDATE-ppf.start_date) - ( TRUNC( (SYSDATE-ppf.start_date) /365) * 365) )) -
TRUNC(((SYSDATE-ppf.start_date) - ( TRUNC( (SYSDATE-ppf.start_date) /365) * 365) )/30) * 30 DIA,

Cethy,

Por favor, verifca este link:

http://stackoverflow.com/questions/3015 ... -and-today

A querie mencionada no link acima, permite calcular os anos, meses, dias decorridos a partir de uma data
(La querie mencionada arriba permite calcular los años, meses y días a partir de una fecha especifica).

select trunc(months_between(sysdate,dob)/12) year,
trunc(mod(months_between(sysdate,dob),12)) month,
trunc(sysdate-add_months(dob,trunc(months_between(sysdate,dob)/12)*12+trunc(mod(months_between(sysdate,dob),12)))) day
from (Select to_date('15122000','DDMMYYYY') dob from dual);

Abraços,
(Cordiales saludos)

Sergio