Posts by Daniel Sorensen • 21 points

• 2

  votes

  8

  answers

  48170

  views

  A: How to calculate a person’s age in SQL Server?

  declare @dataNasc datetime ='1973-06-03' SELECT idade= convert (int, convert( decimal,convert (varchar( 10), getdate(), 112)) /10000 - convert( decimal,convert (varchar( 10), @dataNasc , 112))…

  sql database sql-server tsql

  answered 9 years, 5 months ago Daniel Sorensen 21