note
flexvault
<p><a href="http://www.perlmonks.org/?node_id=109">Dear Monks</a>,</p>
<p>I know little about 'mysql' but what does the following do:
<code>
"SELECT format(filed,3) FROM table WHERE id = 1"
</code>
you state:
<code>
I get 1679971.000
</code>
That looks to me that 'format(filed,3)' is formating the number to 3 decimal places. What happens if you change it to 'format(filed,0)'?
</p><p>Hope it helps!
</p>
<p>Regards...Ed</p>
<div class="pmsig"><div class="pmsig-733061">
<p><b>"Well done is better than well said." - Benjamin Franklin</b></p>
</div></div>
1145098
1145098