Home Forums SQL Server 2005 Development Producing dates from SYSJOBS and SYSJOBHISTORY RE: Producing dates from SYSJOBS and SYSJOBHISTORY

  • August 9, 2008 at 2:54 am

    #855644

    DECLARE@d INT,

    @t INT

    SELECT@d = 20080504,-- May 4, 2008

    @t = 42412-- 4:24:12 AM

    SELECTCAST(STR(@d, 8, 0) AS DATETIME),

    CAST(STUFF(STUFF(STR(@t, 6, 0), 3, 0, ':'), 6, 0, ':') AS DATETIME)

    N 56°04'39.16"
    E 12°55'05.25"