Jump to content


This topic is now archived and is closed to further replies.


Selecting records added between two different dates

Recommended Posts


I'd need an example of a query how to SELECT data between two given dates in mysql, I need it for my search function..

I think I'd need to somehow make sql convert given dates to different format than regular date (LIKE 2006-06-05)..

So basicly something like this my query would be (english good, me Ralph :D):

SELECT id FROM lists WHERE list_date_added BETWEEN 2006-06-01 AND 2006-06-06

That doesn't ofcourse work, it's like I told SQL to SEE if an elephant is more than 3..

Any help with this is appreciated greatly, thank you in advance!

Share this post

Link to post
Share on other sites
Should be fine -- just add quotes around your date to make them proper string literals.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.