Home Forums SQL Server 2008 T-SQL (SS2K8) Adding Minutes(varchar) to a datetime field RE: Adding Minutes(varchar) to a datetime field

  • March 27, 2015 at 10:24 am

    #1786975

    ScottPletcher (3/27/2015)

    Just add them and SQL will implicitly convert the varchar to a datetime anyway:

    SELECT datetime_column + time_varchar AS new_datetime, ...

    FROM ...

    Until the locale driven implicit conversion starts to produce 16:55 AM....;-)

    😎