Home Forums SQL Server 7,2000 SQL Server Newbies How to update just the year in date fields (non datetime data type) RE: How to update just the year in date fields (non datetime data type)

  • May 18, 2012 at 1:37 pm

    #1489932

    Had to reduce the value of you BIGINT (other wise - overflow error)

    but here goes

    DECLARE @b-2 BIGINT

    SET @b-2 = 922337

    SELECT convert(VARCHAR(20),CAST(@B AS DATETIME),101)

    Result: 04/10/4425

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]