mig1980
asked on
SQL Query question
Good day. I am trying to use the following to round for an Age element but I get a number with 6 zeros after it.
Example: 14.000000
The quey is Round((DateDiff(d,id.DOB,' 2012-11-01 ')/365.25) ,0) as Age
Any idea how I can get it so that it doesn't show the zeros?
Example: 14.000000
The quey is Round((DateDiff(d,id.DOB,'
Any idea how I can get it so that it doesn't show the zeros?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER