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 |
|---|
| 9722 |
| 7833 |
| 8705 |
| 8852 |
| 7721 |
| 10089 |
| 9752 |
| 8726 |
| 10822 |
| 9001 |
| 7540 |
| 7155 |
| 8086 |
| 7309 |
[Access] SELECT date() - hiredate FROM emp;
[Oracle] SELECT trunc(sysdate - hiredate) FROM emp;