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 11:06 am

    #1786993

    Eirikur Eiriksson (3/27/2015)

    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....;-)

    😎

    Hmm, how could that happen? SQL will first convert the varchar to a datetime, then add the two, right!?

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