Date intervals - the interval of time between two dates. How many days has each employee worked?
SELECT to_days(current_date) - to_days(hiredate) as "Days Worked" FROM emp;
| Days Worked |
|---|
| 9680 |
| 7791 |
| 8663 |
| 8810 |
| 7679 |
| 10047 |
| 9710 |
| 8684 |
| 10780 |
| 8959 |
| 7498 |
| 7113 |
| 8044 |
| 7267 |
[Access] SELECT date() - hiredate FROM emp;
[Oracle] SELECT trunc(sysdate - hiredate) FROM emp;