Advanced Search

MySQL Time Ago function

/ Published in: MySQL
Save to your folder(s)
Retrieves a relative time in a MySQL Query

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. # Relative Time
  2. DATE_SUB( NOW( ) , INTERVAL 25 HOUR )
  3.  
  4. # For example:
  5. # Select all users who were updated in the last 25 hours.
  6. SELECT * FROM users
  7. WHERE users.updated > DATE_SUB( NOW( ) , INTERVAL 25 HOUR );
  8.  
  9. # Select all users who were updated in the last 2 days.
  10. SELECT * FROM users
  11. WHERE users.updated > DATE_SUB( NOW( ) , INTERVAL 2 day );

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.