Execute Command and Now()

Question

DataContext.ExecuteCommand("DELETE from Table WHERE Date < Now()");

I get an error about how Now() is not a recognized built in function name.

Answer 1

Could that be GetDate() instead of Now()?

Answer 2

Now() is not TSQL. Use GETDATE() or GETUTCDATE()

Answer 3

You should use GETDATE() instead of NOW()

Answer 4

I don't think Now() is a recognized function in SQL.

Answer 5

When you send your SQL query directly to SQL Server, you need to use the SQL Server functions - not the .NET ones.

Use this instead:

DataContext.ExecuteCommand("DELETE from Table WHERE Date < GETDATE()");

GETDATE() is the T-SQL equivalent for Now()