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