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 |
|---|
| 9625 |
| 7736 |
| 8608 |
| 8755 |
| 7624 |
| 9992 |
| 9655 |
| 8629 |
| 10725 |
| 8904 |
| 7443 |
| 7058 |
| 7989 |
| 7212 |
[Access] SELECT date() - hiredate FROM emp;
[Oracle] SELECT trunc(sysdate - hiredate) FROM emp;