SQL Server Performance Forum – Threads Archive
time format
hi all, i have one time field column like 12.00 AM11.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.SQL-Server-Performance.Com
@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.
]]>