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.
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.