-
[RESOLVED] Compare Dates
I'm trying to select only records in my database (mySQL) after a certain date but when I use the strtotime() function it returns the "time" in mm/dd/yyyy format where as I am working in dd/mm/yyyy format. How do I overcome this?
PHP Code:
//If you test the below code the $mytime will be greater then time() which is can't be??
$mytime = strtotime("09/03/2006");
echo "MyTime = $mytime and " . time() ."<br>";
-
Re: Compare Dates
lintz:
I think you might want to use the Date_Format function?
You can read about it in the manual at:
http://dev.mysql.com/doc/mysql/searc...Fen%2F&lang=en