var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: convert decimal to integer
I was wondering if you could help me.
I have an sql which select a field that returns a floating value.
The floating value has 4 decimal places i.e. euro_amount = 12.0000
I would like the euro_amount to be 12 only rather than 12.0000
How can I convert the floating value to an Integer in SQL ?
I would be most grateful if you could let me know.
Thanks in advance
Check some of the functions here:
ROUND or FLOOR sounds like you best bet, followed by a CONVERT to INT (if you *really* need the datatype to be an int).