Date Comparison Issue

[Icarus]

Hi all,

I am trying to create a stored procedure that will check a date field.
I want to check for records that are equal to or greater then 90 days
from the current date. I am trying to check this against a field
called LastUpdate. Is there an easy way in SQL to do this?

TIA

[John Gilson]

"Icarus" <ch*********@NOSPAMreardenweb.com> wrote in message
news:df********************************@4ax.com...

Hi all,

I am trying to create a stored procedure that will check a date field.
I want to check for records that are equal to or greater then 90 days
from the current date. I am trying to check this against a field
called LastUpdate. Is there an easy way in SQL to do this?

TIA

SELECT *
FROM T
WHERE LastUpdate <= CURRENT_TIMESTAMP - 90

Regards,
jag

[David Portas]

....
WHERE lastupdate >=
DATEADD(DAY,-90,CONVERT(CHAR(8),CURRENT_TIMESTAMP,112))

--
David Portas
------------
Please reply only to the newsgroup
--

"Icarus" <ch*********@NOSPAMreardenweb.com> wrote in message
news:df********************************@4ax.com...

Hi all,

I am trying to create a stored procedure that will check a date field.
I want to check for records that are equal to or greater then 90 days
from the current date. I am trying to check this against a field
called LastUpdate. Is there an easy way in SQL to do this?

TIA

[Icarus]

Thanks! Worked perfectly.

On Tue, 18 Nov 2003 15:48:07 GMT, "John Gilson" <ja*@acm.org> wrote:

"Icarus" <ch*********@NOSPAMreardenweb.com> wrote in message
news:df********************************@4ax.com.. .

Hi all,

I am trying to create a stored procedure that will check a date field.
I want to check for records that are equal to or greater then 90 days
from the current date. I am trying to check this against a field
called LastUpdate. Is there an easy way in SQL to do this?

TIA

SELECT *
FROM T
WHERE LastUpdate <= CURRENT_TIMESTAMP - 90

Regards,
jag