php - Zend DB - Max Time does not return the latest time -


i have follow table value timestamp.

[ttimestamp] column 2013-07-11 11:52:19 2013-07-11 11:52:23 2013-07-11 11:52:27 

however, instead of return latest time following query, returns smallest... why?

$select = $this->dbo->select(array("max(ttimestamp)"))     ->from(array('t' => 'table')); 

there has been bug report http://bugs.mysql.com/bug.php?id=54784. not sure version running. should work if max(unix_timestamp(ttimestamp))


Comments

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -