Date_Sub(NOW) error

Question

I get errors

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

SQL stored procedure:

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

Answer 1

In SQL Server, what you are trying to do might look like this:

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