advanced code snippet search

Posted By

hasantayyar on 07/31/09


Tagged

mysql date


Versions (?)

Who likes this?

4 people have marked this snippet as a favorite

vali29
irishsk
umang_nine
ignace


MySQL: Get all MySQL rows that are one week old

 / Published in: PHP
 

URL: http://snippetsmania.com/snippet/MySQL/Get_all_MySQL_rows_that_are_one_week_old/96

Expand | Embed | Plain Text 
  1. SELECT DATE_SUB(date_time_column, INTERVAL 1 WEEK) FROM your_table;

Report this snippet  

You need to login to post a comment.