datediff substitute in mysql 3.23.58

[JoeAtRevolutionUnltd]

I'm looking for a way to subtract and event date from the current date in order to find upcoming events.

This is a piece of the old working code.

$SQL = 'SELECT * 
	FROM events e
	WHERE DATEDIFF("'.$today.'",e.E_End_Date) <= 1 ';

 

[r937]

note you do not need to feed in to mysql the value of the current date, mysql knows what the current date is

... WHERE TO_DAYS(e.E_End_DATE) - TO_DAYS(CURRENT_DATE) <= 1

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[DonQuichote]

mysql knows what the current date is

True, but if you have a separate web server and database server, you should read the dates from one server only or face some funny and inexplicable results when one of those servers has its clock out of tune. So if you save dates from PHP, it is actually good to compare them with dates from PHP.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[r937]

in that case, php should ask the database, because as we all know, the database is never wrong

;-)

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon