how to determine if record was last updated 60 min ago

[lizok]

Hi

i am trying to write a query that would pull all records from the table where record was last updated 60 min ago and flag them?

aim a little confused with datepart (is that what i use?) to determine was 60 min since the last update?

i'd appreciate any help. (and sample code )
thank you
liz

 

[SQLSister]

Do you want records that were updated more than 60 minutes ago, less than 60 minutes or exactly 60 minutes?

Also do you have a field inyour database that stores the date of the last update?

Questions about posting. See faq183-874

 

[dbomrrsm]

Update yourtable
set yourflag = 'Y'
where updatetimefield = dateadd(hh,-1,GETDATE())

[blue]DBomrrsm[/blue]

 

[donutman]

1) Yes
2) Yes

 

[lizok]

I am resetting the flag for those users who update their records =60 or more minutes ago.

i have a field "LastUpdateDT" that is set on every page onLoad event.

 

[lizok]

this query doens't pull any records
Update yourtable
set yourflag = 'Y'
where updatetimefield = dateadd(hh,-1,GETDATE())

i have one set to: 12/16/2004 7:30:36 AM and it shdoul have been pulled.
i've tried n,-60- same result- nothing

 

[SQLSister]

try <= insaead of =

your current query would only give you results that were exactly 60 minutes ago.

Questions about posting. See faq183-874

 

[dbomrrsm]

Not only that and to be more specific - it would only give you records that were exactly to the second 60 minutes old.

you may want to convert the times to strip off the seconds so it only matches on minutes or 60 of them ago.

[blue]DBomrrsm[/blue]