AGE OF AN EMPLOYEE

CGN007
Posted by CGN007 under Sql Server category on | Points: 40 | Views : 1082
SELECT emp_name,DATEDIFF(YEAR,emp_dob,getdate())AS DOB FROM employee

Comments or Responses

Posted by: Ras90it on: 5/30/2012 Level:Starter | Status: [Member] | Points: 10
here what is emp_name, DATEDIFF, YEAR, emp_dob, getdate() as DOB ???

can u explain in detail with syntax?

by using this state what will the the O/P with sample???

Login to post response