time format | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

time format

hi all, i have one time field column like 12.00 AM
11.00 PM
i want chang into railway time.
advanced thanks

Do you mean 24-hour clock.
Lookin BOL for convert function with style.
DATEPART in this case andhttp://www.databasejournal.com/features/mssql/article.php/2197931 for examples. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.