How do I query for records older than 3 months to the day? 2

[hockEdeals]

How do i select items in my database older than 3 months. I'm using getdate() to store it when it's created and i want to query items that are older than 3 monts. I'm using smalldatetime in the field.

 

[SQLBill]

Use this:

SELECT DATEADD(MONTH, -3, GETDATE())

-SQLBill

 

[hockEdeals]

In the end i want to automatically delete all entries older than 3 months. They are users who are inactive. The field is called LastLoginDate and i'm using GetDate() to store it initially whenever the user logs on, it will update. I want to be able to click a button and run a delete where LastLoginDate in Table UserData where date is older than 3 months. I tried yours but and it gave me 2003-12-23 12:25:54.233. Any Ideas? Thanks in advance!

 

[checkai]

2003-12-23 12:25:54.233 is 3 months ago...not sure what else you need

delete from table
where lastlogindate<DATEADD(MONTH, -3, GETDATE())

???

 

[SQLBill]

2003-12-23 13:40:25 IS three months ago as of the moment I typed this. If that's not what you want, then what DO you want?

-SQLBill

 

[hockEdeals]

lol, that's was right i just didn't know how to write it as a select statement with where. Sorry, that's exactly what i needed. THANKS SQLBILL & CHECKAI!