Quote:
Originally Posted by chaitanyacrn
Hai frnds can u tell me the simple syntax using one example how caluclate the aage using system date.i am hanving only DOB field in my table.
select datediff(year,DOB,getdate()) from table
Showing posts with label calucation. Show all posts
Showing posts with label calucation. Show all posts
Friday, February 24, 2012
Age calucation
Hai frnds can u tell me the simple syntax using one example how caluclate the aage using system date.i am hanving only DOB field in my table.
select datediff(year,DOB,getdate()) from table
select datediff(year,DOB,getdate()) from table
Subscribe to:
Posts (Atom)