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;