Post reply

decimal places correction

  • November 27, 2017 at 6:00 am

    #329996

    Hi All,

    I want my numbers to be converted from a column which is of nvarchar(100) datatype to decimal(18,2).
    How can I correct it?

    select CONVERT(DECIMAL(18,2),'129399389')

    --I' am getting output as
    129399389.00

    But I am expecting output as
    1293993.89

    Thanks,

    Sam

  • November 27, 2017 at 6:19 am

    #1969506

    You need to CONVERT and then divide by 100. An Integer, as a decimal, doesn't change its value.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • November 27, 2017 at 6:24 am

    #1969508

    Thanks Thom.

  • November 27, 2017 at 7:34 am

    #1969526

    vsamantha35 - Monday, November 27, 2017 6:00 AM

    Hi All,

    I want my numbers to be converted from a column which is of nvarchar(100) datatype to decimal(18,2).
    How can I correct it?

    select CONVERT(DECIMAL(18,2),'129399389')

    --I' am getting output as
    129399389.00

    But I am expecting output as
    1293993.89

    Thanks,

    Sam

    There is nothing to correct. Datatype conversions do not perform arithmetical operations (though values may change due to rounding).

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 28, 2017 at 5:44 am

    #1969665

    You might also want to consider what happens if your nvarchar(100) column contains more than 16 digits.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply