Having problem with DATEDIFF

[limester]

Hi,

I am trying to calculate a persons age using DATEDIFF. I have a column birthdate (ANSII format yyyy.mm.dd).

This is my query that is failing:

select datediff('year', birthdate, now()) from table1 where table1.column1 = 'value'

Can anyone help me modify this to get the age (in years)?

Thanks.

 

[limester]

Sorry syntax error, was not supposed to use the single quotes for year.

Thanks.

 

[earthandfire]

faq183-5842


Hope this helps

 

[limester]

Thanks earth and fire.

My query worked fine once I removed the quotes from the year. I also made a modification so that the date is more accurate and will compensate for a leap year:

convert(int, Datediff(dd, birth_date, getdate())/365.25)

Thanks.