Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Getting Age in SQL

Author  Topic 

Constraint Violating Yak Guru

298 Posts

Posted - 2001-02-08 : 14:29:15
Hello all.

I have been trying to find out if there is a simple
way to get someones age given their date of birth using SQL only.

I have the code in Javascript, but there are some major issues with javascript and dates.

I could code it in vbscript, but I don't like its reliability too
much either.

I know general sql,but I am not sure what I need to do
to have the age returned in a sql statement.

Anything to help is appreciated.

Sql Server 7, iis 4. nt 4

Software Composer

- Advertisement -