Home Forums SQL Server 2008 T-SQL (SS2K8) Building DATETIME from two strings RE: Building DATETIME from two strings

  • February 8, 2016 at 10:13 am

    #1857177

    Interesting. The code below should work fine. What error are you getting? Are you sure that time is always formatted correctly?

    SELECT CAST(LEFT([Date],8)+' '+Time_on AS datetime)

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.