MySQL SELECT last few days

Question

I was playing with MYSQL and I know there s a limit command that shows a certain amount of results  but i was wondering if MySQL alone can show only the last 3 days or something  Just wondering   Update  I used NOW   to store times

User · Answer

You can use this in your MySQL WHERE clause to return records that were created within the last 7 days/week:

created >= DATE_SUB(CURDATE(),INTERVAL 7 day)

Also use NOW() in the subtraction to give hh:mm:ss resolution. So to return records created exactly (to the second) within the last 24hrs, you could do:

created >= DATE_SUB(NOW(),INTERVAL 1 day)

User · Answer

Use for a date three days ago   WHERE t date  gt   DATE ADD CURDATE    INTERVAL -3 DAY     Check the DATE ADD documentation   Or you can use   WHERE t date  gt     CURDATE   - INTERVAL 3 DAY

User · Answer

SELECT DATEDIFF NOW   pickup date  AS noofday  FROM cir order  WHERE DATEDIFF NOW   pickup date  gt 2    or      SELECT    FROM cir order  WHERE cir order  cir date   gt   DATE ADD  CURDATE    INTERVAL -10 DAY

User · Answer

You could use a combination of the UNIX TIMESTAMP   function to do that   SELECT     FROM     WHERE UNIX TIMESTAMP   - UNIX TIMESTAMP thefield   lt  259200

User · Answer

WHERE t date    DATE ADD CURDATE    INTERVAL  -3  DAY     use quotes on the -3 value

[mysql] MySQL SELECT last few days?

Examples related to mysql

Examples related to sql