txt3rob — 2014-07-03T05:35:28-04:00 — #1
SELECT MAX(ringtime) FROM `south`
Is returning 9 from the below colum any ideas why it's not 23?
john_betong — 2014-07-03T06:22:13-04:00 — #2
9 is the highest string value. Are you wanting the highest numeric value!
txt3rob — 2014-07-03T06:23:15-04:00 — #3
ah yes please
txt3rob — 2014-07-03T06:36:24-04:00 — #4
SELECT ringtime FROM north ORDER BY ABS(ringtime) DESC
This worked and just changed the structure to int also
john_betong — 2014-07-03T07:14:27-04:00 — #5
[TD="class: votecell"][CENTER]6down voteaccepted[/CENTER]
[TD="class: answercell"]Do not mixed varchar with numeric,
idea solution is only stored numeric for used of max aggregate function,
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.
system — 2014-10-08T02:16:16-04:00 — #6
This topic is now closed. New replies are no longer allowed.