Home Forums SQL Server 2008 SQL Server 2008 - General Char(9) to Time RE: Char(9) to Time
Andrew Watson-478275
SSCarpal Tunnel
Points: 4652
More actions
April 5, 2013 at 10:39 am
#1604020
It's a bit of a bodge and wouldn't work if your times stretched to hh:mm:ss rather than just mm:ss, but this does the trick.
order by convert(decimal(5,2),REPLACE(colname,':','.'))