Microsoft SQL ~ convert to integer

Ap_Skus.Price1 as Price1

0.00
420.00
558.00
88.00
440.00
0.00
149.00


cast(Ap_Skus.Price1 as Integer) as Price1

0
420
558
88
440
0
149



select cast(100.21234 as integer)

100

沒有留言: