Post reply

Float to Varchar

  • August 8, 2015 at 1:26 pm

    #319571

    Comments posted to this topic are about the item Float to Varchar

    Thanks,
    Naveen.
    Every thought is a cause and every condition an effect

  • August 9, 2015 at 11:55 am

    #1818404

    Thanks for the question

    Not sure if the following link provides a better explanation.

    https://msdn.microsoft.com/en-us/library/ms187928.aspx

    I based my answer on the part about the style which says that the default is 6 digits.

    -------------------------------------------------------------------------------------------------------------------------------

    When expression is float or real, style can be one of the values shown in the following table. Other values are processed as 0.

    Value

    Output

    0 (default)

    A maximum of 6 digits. Use in scientific notation, when appropriate.

    1

    Always 8 digits. Always use in scientific notation.

    2

    Always 16 digits. Always use in scientific notation.

    126, 128, 129

    Included for legacy reasons and might be deprecated in a future release.

  • August 10, 2015 at 4:22 am

    #1818470

    jan.dewettinck (8/9/2015)

    Thanks for the question

    Not sure if the following link provides a better explanation.

    https://msdn.microsoft.com/en-us/library/ms187928.aspx

    I based my answer on the part about the style which says that the default is 6 digits.

    -------------------------------------------------------------------------------------------------------------------------------

    When expression is float or real, style can be one of the values shown in the following table. Other values are processed as 0.

    Value

    Output

    0 (default)

    A maximum of 6 digits. Use in scientific notation, when appropriate.

    1

    Always 8 digits. Always use in scientific notation.

    2

    Always 16 digits. Always use in scientific notation.

    126, 128, 129

    Included for legacy reasons and might be deprecated in a future release.

    +1 and thanks for this short but full and easy explanation.

    As I knew that the default number of digits was 6 , the answer to find was too easy.

    But thanks to the Creator of this QOT as it is good to post this kind of question.

  • August 10, 2015 at 5:16 am

    #1818486

    An easy one to start the week. Thanks.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • August 10, 2015 at 5:30 am

    #1818491

    jan.dewettinck (8/9/2015)

    Thanks for the question

    Not sure if the following link provides a better explanation.

    https://msdn.microsoft.com/en-us/library/ms187928.aspx

    I based my answer on the part about the style which says that the default is 6 digits.

    -------------------------------------------------------------------------------------------------------------------------------

    When expression is float or real, style can be one of the values shown in the following table. Other values are processed as 0.

    Value

    Output

    0 (default)

    A maximum of 6 digits. Use in scientific notation, when appropriate.

    1

    Always 8 digits. Always use in scientific notation.

    2

    Always 16 digits. Always use in scientific notation.

    126, 128, 129

    Included for legacy reasons and might be deprecated in a future release.

    +1

    😎

    Default style (0) will return 6 digits.

  • August 10, 2015 at 6:02 am

    #1818499

    I based my answer on the part about the style which says that the default is 6 digits.

    I believe this is the actual reason why we get that result. Can verify by changing a bit the excercise:

    declare @f float=115627.473121036902

    select convert(varchar(20), @f)

    Result: 115627

    ---------------
    Mel. 😎

  • August 10, 2015 at 9:36 am

    #1818617

    Yeah, well, be careful using STR() to convert from FLOAT to VARCHAR(), too:

    http://www.sqlservercentral.com/questions/T-SQL/94788/[/url]

    Rich

  • August 10, 2015 at 12:10 pm

    #1818667

    jan.dewettinck (8/9/2015)

    Thanks for the question

    Not sure if the following link provides a better explanation.

    https://msdn.microsoft.com/en-us/library/ms187928.aspx

    I based my answer on the part about the style which says that the default is 6 digits.

    -------------------------------------------------------------------------------------------------------------------------------

    When expression is float or real, style can be one of the values shown in the following table. Other values are processed as 0.

    Value

    Output

    0 (default)

    A maximum of 6 digits. Use in scientific notation, when appropriate.

    1

    Always 8 digits. Always use in scientific notation.

    2

    Always 16 digits. Always use in scientific notation.

    126, 128, 129

    Included for legacy reasons and might be deprecated in a future release.

    Good to know this stuff. Thanks Jan

    Thanks,
    Naveen.
    Every thought is a cause and every condition an effect

  • August 10, 2015 at 12:10 pm

    #1818668

    rmechaber (8/10/2015)

    Yeah, well, be careful using STR() to convert from FLOAT to VARCHAR(), too:

    http://www.sqlservercentral.com/questions/T-SQL/94788/[/url]

    Rich

    Good example on STR() usage.

    Thanks,
    Naveen.
    Every thought is a cause and every condition an effect

  • August 10, 2015 at 1:33 pm

    #1818713

    Very nice - thanks, Naveen!

  • August 11, 2015 at 3:10 am

    #1818818

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 11, 2015 at 2:21 pm

    #1819132

    Great question - and even more counter-intuitive than the answers usually are!

    Thanks.

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • August 18, 2015 at 7:41 am

    #1820725

    Nice one, good to know, thanks.

Viewing 13 posts - 1 through 12 (of 12 total)

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