SELECT MAX(ringtime) FROM `south`
Is returning 9 from the below colum any ideas why it’s not 23?
SELECT MAX(ringtime) FROM `south`
Is returning 9 from the below colum any ideas why it’s not 23?
9 is the highest string value. Are you wanting the highest numeric value!
ah yes please
would
SELECT ringtime FROM north ORDER BY ABS(ringtime) DESC
be correct?
This worked and just changed the structure to int also
Try this:
[TABLE]
[TR]
[TD=“class: votecell”][CENTER]6down voteaccepted[/CENTER]
[/TD]
[TD=“class: answercell”]Do not mixed varchar with numeric,
idea solution is only stored numeric for used of max aggregate function,
alternatively
max( cast(value as unsigned) )When you are doing a MAX, is a cast to string.
When you are doing comparison, is a cast to numeric.
Reason?
http://dev.mysql.com/doc/refman/5.0/en/
[/TD]
[/TR]
[/TABLE]