Home Forums SQL Server 2005 SQL Server 2005 General Discussion Convertsionsproblem between timestamp and bigint RE: Convertsionsproblem between timestamp and bigint

  • August 7, 2009 at 1:34 am

    #1035811

    Thank you for your reply's.

    I tested some more with your informations. I think

    SELECT 'THIS WORK'

    , CONVERT(timestamp,2147483647)

    , CONVERT(Bigint,CONVERT(timestamp,2147483647))

    , 2147483647

    UNION

    SELECT 'DON''T WORK'

    , CONVERT(timestamp,2147483648)

    , CONVERT(Bigint,CONVERT(timestamp,2147483648))

    , 2147483648

    UNION

    SELECT 'Work also with gt 2^21-1 ; -)'

    , CONVERT(timestamp,CONVERT(bigint,2147483648))

    , CONVERT(Bigint,CONVERT(timestamp,CONVERT(bigint,2147483648)))

    , 2147483648

    order by 4

    should work for me.

    I kow this will either no work at the 2^63-1 Mark.