Home Forums SQL Server 2008 T-SQL (SS2K8) Age RE: Age
valeryk2000
SSCarpal Tunnel
Points: 4245
More actions
November 18, 2013 at 9:57 am
#1667194
Just bumped on this:
DECLARE @dob datetime
SET @dob='1992-01-09 00:00:00'
SELECT DATEDIFF(YEAR, '0:0', getdate()-@dob)
Works ok. Who can explain '0:0' ?