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 · Accepted 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

You can use this in your MySQL WHERE clause to return records that were created within the last 7 days week   created  gt   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  gt   DATE SUB NOW   INTERVAL 1 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

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

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