PHP Datetime

Discussion in 'PHP' started by Dehisce, Nov 23, 2008.

0
  1. #1
    In my mysql I have a datetime. How do I run a query on that to select entries from last 3 minutes?
     
    Dehisce, Nov 23, 2008 IP
  2. wmtips

    wmtips Well-Known Member

    Messages:
    601
    Likes Received:
    70
    Best Answers:
    1
    Trophy Points:
    150
    #2
    SQL:
    select * from table where datefield >= date_sub(NOW(),interval 3 minute)
    Code (markup):
     
    wmtips, Nov 23, 2008 IP