Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculating Age
Message
From
06/03/2002 10:11:42
Eugenijus Rimkus
SPAB Siauliu energija
Siauliai, Lithuania
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Calculating Age
Miscellaneous
Thread ID:
00627078
Message ID:
00628995
Views:
22
Hi,

declare @dot datetime
SET @dot = '03/21/1984'

Select Datediff(Month, @dot, getdate())/12 as age
Select Datediff(Day, @dot, getdate())/365 as age
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform