In Azure Stream Analytics query how do you concatenate strings together?

Question

I'm attempting to modify one of my data values by concatenating a string to a date.

Below is what I've tried for my query but there seems to be some problem with my syntax.

Can someone point out what I'm doing wrong?

Answer 1

Try casting to a string first:

CONCAT(
 CAST(created as nvarchar(max)),
 ' something else to concatenate' 
)