Decode Function

[LeighDreyer]

Tryint to check if a persons age is over 65 if so place a Y in table else place a N in table this is my attempts with no luck

Method 1
DECODE(ROUND((F.TODAYS_DATE - C.DATE_OF_BIRTH) / 365) AS "AGE"

Method 2
Decode(Sign(65-ROUND((F.TODAYS_DATE - C.DATE_OF_BIRTH) / 365)), 1, N, Y )

anyone know how to do this ?

 

[JamesLean]

UPDATE table_name
SET IsOver65 = CASE WHEN date_of_birth < DATEADD(yy, -65, getdate()) THEN 'Y' ELSE 'N' END

--James

 

[clapag22]

case
when datediff(day, c.date_of_birth, f.todays_date)/365.25 >= 65 then 'Y'
else 'N' end

 

[LeighDreyer]

Tried the Datediff one and keep getting error on Datediff saying Invalid Coloumn name ????

case
when datediff(DAY, C.DATE_OF_BIRTH, F.TODAYS_DATE)/365.25 >= 65 then 'Y'
else 'N' end

 

[LeighDreyer]

maybe I should have said that I am not performing an update it is inside a select Statement as below

SELECT A.NAME AS "WARD NAME",
F.TODAYS_DATE AS "DATE",
DECODE(C.SEXXX_REFNO,'250564','M','250416', 'F') AS "SEX",
(ROUND((F.TODAYS_DATE - C.DATE_OF_BIRTH) / 365) AS "AGE"

need to convert it in here if possible ?.