Get rows whose date is within 72 hours?

Discussion in 'MySQL' started by Octane, Jul 13, 2011.

0
  1. #1
    Hi guys!

    I'm trying to grab all rows whose "date of stay" is within a 72 hour period.

    So, if you went to your calendar and looked at todays date, you'd be looking for all events within the next three days.

    The field stay_date is of type timestamp, just to head off the obvious question.

    I've got all of the query in place, except the WHERE clause for the aforementioned.

    Any ideas?
     
    Octane, Jul 13, 2011 IP
  2. dazst

    dazst Active Member

    Messages:
    115
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    78
    #2

    SELECT ... WHERE stay_date BETWEEN unix_timestamp() AND unix_timestamp() + (72 * 3600)
     
    dazst, Jul 13, 2011 IP
  3. Octane

    Octane Peon

    Messages:
    117
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Dazst, thanks for the prompt response!

    Given that I'm on a tight schedule, I had to forge on and figured out an alternate solution:
    But thanks all the same!
     
    Octane, Jul 13, 2011 IP