Page 1 of 1

How to Truncate AND Calculate ??

Posted: Sun Dec 19, 2004 1:56 pm
by pookie62
Hi all,

I want to truncate a number, which is going fine, but how to calculate a serie of numbers from which I need the smallest (MIN) and want to Truncate it ???
This is what I tried but is not correct..

TRUNCATE (MIN(`score`.`Tijd`, 2)) AS `Tijd` FROM `deelnemer`

Any ideas ??

Thanks..