How can I figure out how old someone is based on a DateTime birthday ?

krishna kukadiya May 27, 2022 0 109

Forums › SQL › How can I figure out how old someone is based on a DateTime birthday ?

Staff asked 2 years ago

0 Vote Up Vote Down

Umang Ramani Marked As Accepted

Staff answered 2 years ago

You can try this :

declare @dob varchar(MAX) = '2003-05-04 00:00:00'
select CONVERT(int,ROUND(DATEDIFF(hour,@dob,GETDATE())/8766.0,0))

krishna kukadiya