SQL Server: How to concatenate string constant with date?

user2901979 picture user2901979 · Oct 23, 2013 · Viewed 51.4k times · Source
select packageid,status+' Date : '+UpdatedOn from [Shipment_Package] 

The below error is appeared when executing the above code in sql server. The type of UpdatedOn is DateTime and status is a varchar. We wanted to concatenate the status, Date and UpdatedOn.

error:

Conversion failed when converting date and/or time from character string.

Answer

Mahmoud Gamal picture Mahmoud Gamal · Oct 23, 2013

You need to convert UpdatedOn to varchar something like this:

select packageid, status + ' Date : ' + CAST(UpdatedOn AS VARCHAR(10))
from [Shipment_Package];

You might also need to use CONVERT if you want to format the datetime in a specific format.