1. klehonia New Member

   Hi everyone, i want a query that delete rows from a table that are older than 3 days. There is a column with the datetime.
   Thanks in advance
   

   klehonia, Sep 14, 2009

   #2
2. FrankKalis Moderator

   DELETE MyTable WHERE DateTimeColumn < DATEADD(DAY, -3, GETDATE())
   Note that because of the time portion involved here, the statement does not delete rows from 3 days ago where the time was later than the current time. If that is not what you want you would have to strip out the time portion in GETDATE().
   

   FrankKalis, Sep 14, 2009

   #3
3. klehonia New Member

   Thank you very much. It works fine.
   

   klehonia, Sep 14, 2009

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in