So, you want the maximum date of the result set? Just use SQL: select max(datecolumn) from table where (conditions); -Micah On Monday 30 January 2006 1:03 pm, xkorakidis wrote: > hi guys! > I'm trying to manage a table containing a timestamp colum > - when I insert a record, I don't fill a value in timestamp column, so > current timestamp is inserted. The inserted value is smth like > 20060129213253 > - when I try to show this value in a php page, I use > date($varOfTimestampColumn) or getdate(). The final result is the > highest possible date (smth like January 19 2038 I think) > > How can I manage the timestamp field so as to show the correct value? > Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php