1. rv62 New Member

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

   rv62, Jul 26, 2007

   #2
2. ranjitjain New Member

   Do you mean 24-hour clock.
   Lookin BOL for convert function with style.

   ranjitjain, Jul 27, 2007

   #2
3. satya Moderator

   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.

   satya, Jul 27, 2007

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in