Home Forums SQL Server 2008 SQL Server 2008 - General Char(9) to Time RE: Char(9) to Time

  • April 5, 2013 at 10:55 am

    #1604030

    order by convert(decimal(5,2),REPLACE(TestDate,':','.'))

    Doesn't work for hours:min:sec either: Error converting data type varchar to numeric

    If you don't stand for something, you'll fall for anything!,

    Don Urquhart