datetime format in table design???

• nicholas-250056

  SSC Enthusiast

  Points: 107

  More actions

  August 8, 2005 at 5:42 pm

  #110170

  Good Day, nicholas here! Can i know is there any way to change datetime format to 13:00:01(hh:mm:ss)... Please help me!

  Many Thanks!

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 8, 2005 at 8:23 pm

  #580573

  Check out convert in books online, you'll get all the info you need.

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  August 8, 2005 at 8:59 pm

  #580580

  Here's one:

  select convert(char(8), getdate(), 108)

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**