Home Forums SQL Server 2008 T-SQL (SS2K8) Converting Integer Values to Datetime RE: Converting Integer Values to Datetime

  • July 15, 2014 at 1:56 am

    #1729344

    Something like this?

    declare @date int = 20140714, @hour int = 4

    SELECT DATEADD(HOUR,@hour,CONVERT(DATETIME,LEFT(@date,8)))