Post reply

scientific notation and decimals

  • September 22, 2005 at 2:58 pm

    #166087

    HELP .. i have data in a table the field is nvarchar(50)

    the data is '3.6774e-008' i want it to be changed to '3.68e-08' can some one please shove me the right directions ...

     

    thanks !!

  • September 22, 2005 at 3:36 pm

    #592420

    Just convert it to float and apply whatever format you want in front end application.

     

    _____________
    Code for TallyGenerator

  • September 23, 2005 at 7:07 am

    #592581

    In the ideal situation, I think you are better off changing it to decimal, change the scale to nano (x 10-9), and get rid of the exponential part. e.g. 1.23456E-8 Units ==> 12.3456 nanoUnits.  Since you want a format like 12.23, you would change the field to decimal(4, 2), and enforce your 2-digit mantissa (scale) rule automatically (with automatic rounding to a 2-digit mantissa.)

    Since users might be confused at first by the change of units, you could convert from native Units to nano-Units in the client app.

Viewing 3 posts - 1 through 2 (of 2 total)

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