POWER doesn't work for BIGINT?

  • R. van Laake

    SSCommitted

    Points: 1533

    Hi,

    When you try this code:

    DECLARE @a BIGINT

    SET @a = POWER(2,30)

    PRINT @a

    you get:

    1073741824

    When you try this code:

    DECLARE @a BIGINT

    SET @a = POWER(2,31)

    PRINT @a

    you get:

    Msg 232, Level 16, State 3, Line 2

    Arithmetic overflow error for type int, value = 2147483648.000000.

    Why is this? I mean, @a should be able to hold all (positive) values up to 2^63 -1

    Thanks,

    Ray

  • Christopher Stobbs

    SSC-Insane

    Points: 21098

    I think you might be confused

    a bigint takes this

    SET @a = 9223372036854775807

    PRINT @a

    SET @a = POWER(2,31-1)

    PRINT @a

    AND NOT THIS

    SET @a = POWER(2,31)-1

    PRINT @a

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life
  • Christopher Stobbs

    SSC-Insane

    Points: 21098

    actually maybe I am confused I will look further

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life
  • R. van Laake

    SSCommitted

    Points: 1533

    Yep, y'r right, I made a typo.

    However, I got the problem fixed, this does the trick:

    DECLARE @a BIGINT

    SET @a = POWER(CAST(2 AS BIGINT),CAST(62 AS BIGINT))

    PRINT @a

  • Christopher Stobbs

    SSC-Insane

    Points: 21098

    yeah that was my next solution was to perhaps cast the vaules as it would prob return the same type as what is passed in 🙂

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

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

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