8.1 加减日、月、年

分类: IT文章 • 2024-12-30 14:42:30

select hiredate - interval 5 day as   hd_minus_5D,
           hiredate + interval 5 day as   hd_plus_5D,
           hiredate - interval 5 month as hd_minus_5M,
           hiredate + interval 5 month as hd_plus_5M,
           hiredate - interval 5 year as hd_minus_5Y,
           hiredate + interval 5 year as hd_plus_5Y
from emp
where deptno=10;