How to concatenate a string and GETDATE() in MSSQL

sql-server string concatenation getdate
Kjartan picture Kjartan · Aug 9, 2011 · Viewed 37.7k times · Source

I need to insert a string (a comment) which should include a date. What I need is basically the following simple operation:

INSERT INTO [Table_1]
           ([textColumn])
     VALUES
           ('Date: ' + GETDATE())
GO

This however, returns the following error: Conversion failed when converting date and/or time from character string.

Any quick fixes?

Answer

Damith picture Damith · Aug 9, 2011

what is the date time format you need?

select one from here http://www.sql-server-helper.com/tips/date-formats.aspx and convert it to a char as bellow 

INSERT INTO [Table_1]
           ([textColumn])
     VALUES
           ('Date: ' +CONVERT(CHAR(10),  GETDATE(), 120))
GO

Related questions

UPDATE and REPLACE part of a string

I've got a table with two columns, ID and Value. I want to change a part of some strings in the second column. Example of Table: ID Value --------------------------------- 1 c:\temp\123\abc\111 2 c:\temp\123\abc\222 3 c:\temp\123\abc\333 4 c:\temp\123\…

Read More
Remove all spaces from a string in SQL Server

What is the best way to remove all spaces from a string in SQL Server 2008? LTRIM(RTRIM(' a b ')) would remove all spaces at the right and left of the string, but I also need to remove the …

Read More
Check if a string contains a substring in SQL Server 2005, using a stored procedure

I've a string, @mainString = 'CATCH ME IF YOU CAN'. I want to check whether the word ME is inside @mainString. How do I check if a string has a specific substring in SQL?

Read More