How to query data for a certain data range in MySQL

Question

We are using MySQL, and the table have a column named 'createdat` which means the time when the record are inserted.

Now we want to get data within 10 days from its created time.

Something like this:

select xx from table where time_of_now - createdat<= 10

I wonder if MySQL support this kind of query?

shree.pat18 · Accepted Answer · 2014-08-20 08:03:45Z

1

You can use DATEDIFF to get the difference between 2 dates in days, like so:

select xx 
from table 
where datediff(now(),createdat) <= 10

Documentation

edited Aug 20, 2014 at 8:03

answered Aug 20, 2014 at 7:49

shree.pat18

21.8k3 gold badges45 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TJ- Over a year ago

Using dateDiff is not such a good idea here because it will make the index on createdat unusable. The diff for all dates will be calculated first and then that will be compared with 10 (a linear scan)

TJ- · Accepted Answer · 2014-08-20 07:57:27Z

0

select xx from table where createdat >= CURDATE() - INTERVAL 10 day

answered Aug 20, 2014 at 7:57

TJ-

14.4k13 gold badges64 silver badges92 bronze badges

Collectives™ on Stack Overflow

How to query data for a certain data range in MySQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related