title: How to find experience of an employee in ORACLE SQL Developer?
body: <p>I am trying to find the work experience of employees in ORACLE SQL Developer.</p>
  
  <p>I have the following columns in the table <code>employees</code>: <code>Hire_Date(DD-MM-YY)</code>, <code>First_name</code>, <code>Last_Name</code>, <code>Employee_id</code>, <code>Salary</code>, <code>Manager_ID</code> and so on.</p>
  
  <p>I guess I need to apply some conversion but I'm not sure about the method or how to convert it.</p>
  
  <hr>
  
  <p>I tried to subtract hire_date from Sysdate.</p>
  
  <pre class="lang-sql prettyprint-override"><code>Select, Employee_id, First_name, Hire_Date, (Sysdate-Hire_Date) as year_Exp
  from employees;
  </code></pre>
  
  <p>I am getting the output as</p>
  
  <p>Actual result: 5966.52.333333333333333333333333333333333</p>
  
  <p>Expected result: 5 Years or relevant years of experience</p>