sql - 比较列日期/w 今天日期

Question

我正在尝试比较该列：LastUpdated以天为单位的今天日期，四舍五入到小数点后 1 位。我不断收到错误

ERROR at line 4:
ORA-00904: "DATEDIFF": invalid identifier

有任何想法吗？

SELECT
DISTINCT "AppName",
"ApprovedForRelease",
DATEDIFF(DAY,"LastUpdated",GETDATE())  AS "DaySinceUpdated" 
FROM BR_APP
WHERE "ApprovedForRelease" = 'Y';

标签： sqloracle

Answer 1

在 Oracle 中，您可以使用减法。要获取两者之间的日期，请截断时间：

SELECT DISTINCT "AppName", "ApprovedForRelease",
       (TRUNC(sysdate) - TRUNC("LastUpdated"))  AS "DaySinceUpdated" 
FROM BR_APP
WHERE "ApprovedForRelease" = 'Y';

您使用的代码基于 SQL Server。