Home Forums SQL Server 2008 SQL Server 2008 - General Datetime conversion RE: Datetime conversion

  • October 12, 2010 at 9:36 am

    #1235633

    Get rid of the "th" after "24".

    select convert(datetime2,'May 24 2010') AS MyDate

    Results:

    MyDate

    ---------------------------

    2010-05-24 00:00:00.0000000