I want to write script to update some html text to new text. However I get error:
SQL Error [42725]: ERROR: operator is not unique: unknown / unknown
Hint: Could not choose a best candidate operator. You might need to add explicit type casts.
Position: 469
Is it because of html tags? What is the right way to do that?
This is my SQL:
update messaging.email
set body='
text
@TimeZoneInfo.ConvertTimeFromUtc(Model.Timestamp.Value, Model.TimeZoneInfo).ToString("d'/'MM'/'yyyy", Model.CultureInfo)
'
where id = 1
Apparently the error came from escaping "d'/'MM'/'yyyy". So I changed it to "d''/''MM''/''yyyy"