AGE OF AN EMPLOYEE

Posted by CGN007 under Sql Server category on 5/30/2012 | Points: 40 | Views : 1540

Post Code |

Search Codes |

Code Home

SELECT emp_name,DATEDIFF(YEAR,emp_dob,getdate())AS DOB FROM employee

Alert Moderator

Bookmark It

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???

Latest Code Snipptes

Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
How to add star rating and submit rating
MS Dynamics 365 - Create an email activity using dynamics crm Rest API - C#
More ...