How to remove numbers after the decimal point?

prash_

I have an output like 1567.88 and I just want 1567

I tried using the round after round its giving 1568.

Any solution on this?

sj0071992

Hi,

Try using function FLOOR()

This will returns the largest integer value which is less than or equal to the value used as a parameter.

For example: FLOOR(79.9) will give 79

Thanks