Home Forums SQL Server 2005 SQL Server 2005 Strategies Convertion of integer to Datetime format RE: Convertion of integer to Datetime format

  • August 18, 2009 at 3:04 am

    #1040686

    DATETIME to INT

    declare @time1 datetime

    set @time1 = getdate()

    select convert(int,@time1)

    print @time1

    INT to DATETIME

    declare @time int

    set @time = 40042

    select convert(datetime,@time,112)

    print @time