How to Truncate AND Calculate ??
Posted: Sun Dec 19, 2004 1:56 pm
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..
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..