Thread: help with time and max()
Results 1 to 2 of 2
06-19-2005, 08:02 AM #1
help with time and max()
How can I display those records that have a timestamp that is lower than the maximum timestamp expecially if my mysql is version 3 only?
For example: if today is 20050619175932, then the record that has this timestamp will not be displayed, and only the record with 200506191732 will be.
07-11-2005, 12:32 PM #2
Re: help with time and max()
Try converting your timestamp with date(). Example:
you have your time 200.... in $x
$y = date("Y-m-d",$x);
Then you can compare.
I hope it works