VistaDB 6
VistaDB / Developer's Guide / SQL Reference / Functions / Mathematical Functions / INT
In This Topic
    In This Topic
    Returns the integer (whole) part of a real number.


    This does not do any type of rounding. It will only return the whole part of a real number. If you need to round the number use the ROUND function, or look at the CEILING / FLOOR functions.

    This is not the same thing as a cast in C#/VB.Net. This is the math function to get the whole part of a number without rounding.


    SELECT INT(3.1415);
    SELECT INT(3.9999);
    RETURNS: 3

    See Also