SYSDATE system variable?

[NutsMonkey]

Hi, I'm trying to write a query for a report which will ignore recent transactions. I would like to therefore put in the WHERE clause of the SQL query something of the form:

AND OrderDate < ( SYSDATE - 60 )

I have no idea how to express SYSDATE in SQL server syntax. Can anybody help?

Is there a system date standard system variable for querying in the SQL Server environment.

Thanks in Advance

 

[amrita418]

GetDate() is the function you are looking for.

Sample Code:

orderdate <  dateadd(day, -60, convert(varchar, getdate(), 101))

Regards,
AA

 

[nwm76]

Try:

AND OrderDate < (SELECT DATEADD(day, -60, GETDATE()))


GETDATE() is the system function that returns current date.

Use DATEADD for the date arithmetic....second, minute, hour, day, week, month, year etc are all valid for the 1st parameter.

hth,
Neil

 

[Juice05]

Where OrderDate < DateAdd(Month,-1,GetDate())

 

[NutsMonkey]

Thanks Everybody!