Thunderstone Support Forums

Since there is no money data type is there an easy way to convert 16.299999 to 16.29 during the select statement??

You can convert it when you print it in Vortex (after the SELECT):

<fmt "%1.2lf" $value>

or better yet:

<fmt "%1.2klf" $value>

which will print commas every factor of 1000.

actually I am writing this in perl so I was hoping to be able to do it in the select statement. I will use sprintf in perl. thanks.

Use fmt %.2f when displaying the number. 16.29999999 would be properly displayed as 16.30 .

Or use integers and convert to string and insert decimal point when displaying.

%.2f should work in any sprintf variant.