PHP MySQL Date diff

Question

I have the field datetime with DATETIME type in MySQL. In PHP script I set date begin and date end like this: 11/12/1999 and 11/12/2001. In my table datetime saved in the next format: 11.11.1888 00:00:00. How can I compare these dates?

Thanks.

Could you post a code sample that shows how you "set date begin and date end"? And why 1888? — deceze
– deceze ♦, Commented Oct 6, 2010 at 6:48
So your question is "How to find entries between a start date and an end date"? — deceze
– deceze ♦, Commented Oct 6, 2010 at 7:03

CristiC · Accepted Answer · 2010-10-06 07:15:19Z

1

It could be done more easly, but this is one way:

$begindate = strreplace($begindate,'/','.');
$enddate = strreplace($enddate,'/','.');

mysql_query("SELECT * FROM MyTable
WHERE dateField BETWEEN '$begindate 00:00:00' AND '$enddate 23:59:59'");

answered Oct 6, 2010 at 7:15

CristiC

22.7k13 gold badges62 silver badges89 bronze badges

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

Comments

Flask · Accepted Answer · 2010-10-06 07:26:15Z

1

should be something like

SELECT *, STR_TO_DATE(datetime,'%d.%m.%Y') as newdatetime
FROM table
WHERE newdatetime >= STR_TO_DATE('11/12/1999','%d/%m/%Y')
AND newdatetime <= STR_TO_DATE('11/12/2001','%d/%m/%Y');

edited Oct 6, 2010 at 7:26

answered Oct 6, 2010 at 7:19

Flask

4,9841 gold badge23 silver badges39 bronze badges

Collectives™ on Stack Overflow

PHP MySQL Date diff

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related