Home Forums SQL Server 2008 T-SQL (SS2K8) varchar to datetime convertion challenge RE: varchar to datetime convertion challenge

  • April 30, 2013 at 12:20 pm

    #1611364

    I just tried your suggestion as:

    update table

    set MoYear = convert(datetime, stuff(MoYear,3,0,'/01'), 101)

    When I select the table the values are displaying as Dec 1 2012 12:00AM; Aug 1 2012 12:00AM, etc.