time / date function? 1

[yebaws]

When a new entry is added to a table, the timestamp is added with CURRENT_TIMESTAMP. I want to run a query to find all entries in the table that were added, say, 330 days ago or more. I can think of a very roundabout way of doing this, and know that there must be a simple way to do this, but just can't find what it is. Any ideas?

Thanks.

 

[gmmastros]

[tt][blue]
Select *
From YourTable
Where YourTimeStampColumn < GetDate() - 330
[/blue][/tt]

-George

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