Datetime column - help with format

• Senthil T

  Hall of Fame

  Points: 3367

  More actions

  January 15, 2007 at 10:47 am

  #175522

  Hi,

  I have this datetime column, I would like to get the date in this format - '1/15/2007 10:15AM', like in ASP.Net doing a ToShortDateString() + " " + ToShortTimeString().

  I bind the query results to a datalist, so I prefer doing the formatting in the backend. Is this eay to do?

  Thanks.

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  January 15, 2007 at 1:15 pm

  #683332

  Read "CAST and CONVERT" in BOL.

  _____________
  Code for TallyGenerator