Posted by Jens on 11/11/05 11:18

Hi there,

You have to convert the source column to a non-using time format like
ISO:

DELETE FROM MNT_R
WHERE VARCHAR(10),MNT_R.TIMESTAMP < CONVERT(VARCHAR(10),GETDATE()-
30,112)

HTH, Jens Suessmeyer.

• Next in forum: Re: Something Basic
• Prev in forum: How to delete data older than X days, without considering time
• Thread view: Re: How to delete data older than X days, without considering time

[Reply to this message]