Post reply

data type

  • October 29, 2007 at 2:57 pm

    #376547

    what data type should i define a col as for data that is 0.891?

  • October 29, 2007 at 3:09 pm

    #746401

    You can use Float

  • October 29, 2007 at 3:10 pm

    #746402

    You cal also use 'real'.

    float

    - 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308

    Depends on the value of n(Storage)

    real

    - 3.40E + 38 to -1.18E - 38, 0 and 1.18E - 38 to 3.40E + 38

    4 Bytes (Storage)

  • October 29, 2007 at 3:13 pm

    #746403

    i thought float,real and numeric were non-deterministic so you get approximations like 3.99999999999999999994 for the value of 4.00 stored and such...., and it was better to use money or decimal datatypes, like decimal(6,4)?

    am i wrong?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 29, 2007 at 3:19 pm

    #746408

    Decimal(x,y) is a better option.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • October 29, 2007 at 3:24 pm

    #746410

    Yup,Decimal(x,y) is better

  • October 30, 2007 at 6:16 am

    #746592

    Lowell (10/29/2007)

    i thought float,real and numeric were non-deterministic so you get approximations like 3.99999999999999999994 for the value of 4.00 stored and such...., and it was better to use money or decimal datatypes, like decimal(6,4)?

    am i wrong?

    You're right. Decimal is the way to go here:

    DECIMAL(Total Digits, digits to the right of the decimal)

    or in this case:

    DECIMAL (5,4)

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • October 30, 2007 at 6:28 am

    #746599

    I think Decimal(x, y) would be a better option.

    Cheers!

    Sandy.

    --

Viewing 8 posts - 1 through 7 (of 7 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy