concatenate string and datetime?

• Charmer

  SSChampion

  Points: 14903

  More actions

  July 19, 2012 at 7:51 am

  #276077

  Hi Friends,

  I am trying to concatenate a string and datetime....i did it....but after concatenating , i am getting date and time like Jul 19 2012 7:18PM.

  i must get the datetime like 2012-07-19 19:21:01.587 + string value.

  is that possible?

  give me your suggestions friends

  Thanks,
  Charmer

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 19, 2012 at 7:56 am

  #1514850

  Charmer (7/19/2012)

  ---

  Hi Friends,

  I am trying to concatenate a string and datetime....i did it....but after concatenating , i am getting date and time like Jul 19 2012 7:18PM.

  i must get the datetime like 2012-07-19 19:21:01.587 + string value.

  is that possible?

  give me your suggestions friends

  convert(varchar(22),MyDateTimeCol, 121) + ' ' + MyStringCol

• Lowell

  SSC Guru

  Points: 323526

  More actions

  July 19, 2012 at 7:57 am

  #1514852

  i think you can use one of the built in convert formats.

  --2012-07-19 09:56:46.040 MyString

  SELECT CONVERT(VARCHAR,GETDATE(),121) + ' MyString'

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Charmer

  SSChampion

  Points: 14903

  More actions

  July 19, 2012 at 8:02 am

  #1514854

  Thank you Lowell, Lynn...

  I forgot the 121....

  Thanks,
  Charmer