Extracting Only Time From DateTime Field in a Certain Output Format

• Roger Abram

  Hall of Fame

  Points: 3683

  More actions

  December 1, 2009 at 6:07 am

  #135613

  I'm trying to extract the start time of a meeting in the following format:

  3:00 PM

  If I use the following as an example for the code:

  Select CONVERT(CHAR(19), MeetingStart, 0) from MeetingTable

  It returns the following:

  Jan 4 2010 3:00PM

  Is there a way to just return the time but also put a space between 3:00 and PM so that it is

  3:00 PM ?

  Thank you.

  Rog

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  December 1, 2009 at 6:21 am

  #1085727

  Select LEFT(RIGHT(convert(varchar(20), getdate(), 100), 7), 5) + ' ' +

  RIGHT(convert(varchar(20), getdate(), 100), 2)

  ---------------------------------------------------------------------------------

• Mike01

  SSChampion

  Points: 11412

  More actions

  December 1, 2009 at 6:22 am

  #1085729

  Select ltrim(rtrim(substring(CONVERT(CHAR(19), getdate(), 0),12,10)))

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Roger Abram

  Hall of Fame

  Points: 3683

  More actions

  December 1, 2009 at 8:09 am

  #1085833

  Works perfectly! Thank you so much.

  Rog