• ziangij (8/31/2010)


    DECLARE @a INT

    DECLARE @b-2 DATETIME

    SET @b-2 = @a

    implicit conversion from int to datetime works fine 🙂

    Is this dependent on the sql server version?

    Saurabh Dwivedy
    ___________________________________________________________

    My Blog: http://tinyurl.com/dwivedys

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537

    Be Happy!