How to make an SQL server select that only takes

Navigation
1

I have in a table SQL server PosZ column 

PosZ
103.111005555
1.55689866
95.3655523

SELECT PosZ
FROM Table

My question is how do I get only the first number before the Point (.) so that of this result: 

PosZ
103
1
95
    
asked by Juan Carlos Villamizar Alvarez 30.12.2016 в 20:46
source

1 answer

1

Good, try this: 

PosZ
103.111005555
1.55689866
95.3655523

SELECT round(PosZ, 0)
FROM Table

answered by 30.12.2016 / 20:49
source
"Warning: Division by zero" in php Control of active checkboxes (checked) with jquery?