DECIMAL vs INT

[peridian]

Hi all,

Maybe this is a really stupid question, but which is better to use for whole numbers, INT or DECIMAL (x,0)?

I've seen varying recommendations and uses in documentation online. One article suggested that INT is a deprecated data type, which I can't believe.

Any thoughts?

Regards.

[debasisdas]

you need to go for decimal type.