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 |
|---|
| 9569 |
| 7680 |
| 8552 |
| 8699 |
| 7568 |
| 9936 |
| 9599 |
| 8573 |
| 10669 |
| 8848 |
| 7387 |
| 7002 |
| 7933 |
| 7156 |
[Access] SELECT date() - hiredate FROM emp;
[Oracle] SELECT trunc(sysdate - hiredate) FROM emp;