8.2 计算两个日期之间的天数

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

select datediff(ward_hd,allen_hd)
from (
select hiredate as ward_hd
from emp
where ename='WARD'
) x,
(select hiredate as allen_hd
from emp
where ename='ALLEN'
)y;