Search code examples
phpsqlsql-timestamp

SQL query with dynamic WHERE timestamp

How can i get this part of a query to fetch the values by timerange?

Example of a table:

  select * from tablename where timeregister between '2017-01-11' And '2017-01-30';

How could i get the timeregister to be last 7 days? I was trying this:

select * from tablename where timeregister(NOW(), timeregister) <= 7;
Solution

  • Try this....

    <?php 
    $s_date = date('Y-m-d');
    $e_date = date('Y-m-d',strtotime('+7 days'));
    $sql = 'SELECT * FROM tablename WHERE DATE_FORMAT(timeregister, "%Y-%m-%d") BETWEEN "'.$s_date.'" AND "'.$e_date.'"';
?>