Sql query getting datetime range

Question

Hi i am trying to write a query but I am unsure on how to do it. This is the scenario, i want to bring back records which were inserted into the database 30 minutes BEFORE the start of a specific time and 2 hours AFTER. This is what my query looks like;

SELECT  Comment.AddDate,Event.StartTime
FROM Comment
JOIN Users on Users.USERS_ID  = Comment.UserID
JOIN Event ON Users.USERS_ID = Event.UserID
WHERE EventID = 5630

Now from the above i need records which Comment.AddDate was entered 30 minutes before Event.StartTime and 2 hours later. How do i go about doing this?

D.N. · Accepted Answer · 2011-07-29 19:14:42Z

3

SELECT Comment.AddDate, Event.StartTime
  FROM Comment
  JOIN Users ON Users.USERS_ID = Comment.UserID
  JOIN Event ON Users.USERS_ID = Event.UserID
 WHERE EventID = 5630
   AND Comment.AddDate BETWEEN DATEADD(minute, -30, Event.StartTime)
       AND DATEADD(hour, 2, Event.StartTime)

Documentation located here.

edited Jul 29, 2011 at 19:14

answered Jul 29, 2011 at 19:09

D.N.

2,19018 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql query getting datetime range

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related