Home Forums SQL Server 7,2000 T-SQL Converting a varchar to datetime RE: Converting a varchar to datetime

  • May 6, 2005 at 4:05 pm

    #557473

    Not to piddle, but this will perform better.

    update Inventory

    set DateColumn = convert(datetime, DateStringColumn, 101)

    where isdate(DateStringColumn) = 1

    Signature is NULL