答案:SELECT DAYS(CURRENT DATE) - DAYS(date) FROM <表名>
其他:select datediff(day,crdate,getdate()) from sysobjects where name='表名' select days(current date)-days(date) from table
上一个:一条DB2或SQL SERVER 查询问题,有点难度下一个:DB2中如何查询某天是星期几?