sql - Date_Sub(NOW) 错误

Question

我收到错误

'NOW' is not a recognized built-in function name.

SQL 存储过程:

SELECT * FROM BlogPost WHERE BlogDate <= DATE_SUB(NOW(), INTERVAL 1 MONTH);

Answer 1

在 SQL Server 中，您尝试执行的操作可能如下所示:

SELECT *
FROM BlogPost
WHERE BlogDate <= DATEADD(MONTH, -1, GETDATE())