MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: PHP/MySQL date < CURDATE() problem
Posted by: Greg Platt
Date: December 28, 2007 01:13PM

I have a hunch that Curdate() probably ALSO includes the time down to the latest clock tick. Every record in your table is older than the current clock tick... unless you somehow managed to write them tomorrow. Try formatting curdate() using the from_unixtime() function and take a look at what it actually contains. But that would be my guess.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
PHP/MySQL date < CURDATE() problem
Luke Godfrey
December 27, 2007 07:17PM
Re: PHP/MySQL date < CURDATE() problem
Luke Godfrey
December 27, 2007 07:21PM
Re: PHP/MySQL date < CURDATE() problem
Greg Platt
December 28, 2007 01:13PM
Re: PHP/MySQL date < CURDATE() problem
Greg Platt
December 28, 2007 01:16PM
Re: PHP/MySQL date < CURDATE() problem
Greg Platt
December 28, 2007 01:22PM
Re: PHP/MySQL date < CURDATE() problem
Greg Platt
December 28, 2007 01:54PM
Re: PHP/MySQL date < CURDATE() problem
Brian Papantonio
December 28, 2007 02:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.