TimeStamp less 24 hours 1

[hamish75]

Hi,

I urgently need to create the following in SQL:

Delete
all records
from
Bocs.dbo.stats_one
where
TimeStamp is older than 24 hours and
Code begins with "CC"

I’m not a million miles away I think!...I have the following where I am selecting:

SELECT * FROM Bocs.dbo.stats_one WHERE LEFT(Code, 2) = 'CC' and TimeStamp = '  ';

I need to change the select to delete but I don’t know how to do the “TimeStamp is older than 24 hours” bit..

Can anyone help?

Thanks.


Ah dinnae ken...

 

[gmmastros]

And TimeStamp < DateAdd(Hour, -24, GetDate())

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[hamish75]

Thank you.

Ah dinnae ken...