title: Converting a Time to 24 hour time in SQL Server
body: <p>I'm using Microsoft SQL Server 2000 and need to convert my time column to 24 hour time instead of just 9:30 AM, 12:30 PM, etc.  I'm trying to sort this column and I believe its not working because its just looking at things numerically instead of as the time.  I think what I need can be done with the function FORMAT(Time, HH:mm:ss), but that doesn't  seem to be a function in SQL Server, so I'm stuck now.</p>