AGE CALCULATION IN SQL SERVER SELECT STATEMENT

Posted by Jeyaganeshmuniyandi under Sql Server on 3/31/2012 | Points: 10 | Views : 1484 | Status : [Member] | Replies : 2
SELECT DATEDIFF(YY,'12/12/1987',GETDATE()) Age

Thanks,
M.Jeya ganesh



Responses

Posted by: Sksamantaray on: 3/31/2012 [Member] Silver | Points: 25

Up
0
Down
What's wrong in it?

Thanks,
Sanjay

Jeyaganeshmuniyandi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jeyaganeshmuniyandi on: 3/31/2012 [Member] Starter | Points: 25

Up
0
Down
No wrong its correct, in this code execute perfectly in my system

Thanks,
M.Jeya ganesh

Jeyaganeshmuniyandi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response