Select records based on time
I need to be able to do a select statement for all records that are made where they have been updated within 45 minutes prior to a input time.
Example
declare dt datetime
set dt = 2009-04-08 10:58
select memberID, LastName where lastLogin > 45 minutes prior to dt and lastLogin <= dt
Example
declare dt datetime
set dt = 2009-04-08 10:58
select memberID, LastName where lastLogin > 45 minutes prior to dt and lastLogin <= dt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.