This is a really simple syntax issue. I have the following select statement:
SELECT dbo.CONTENT_Event.eventID, dbo.CONTENT_Event.EventName + ' (' + EventOrgName + ')' + EventDate
which returns the following error:
Conversion failed when converting datetime from character string.
All I want to know is the correct syntax for returning the date only from the EventDate datetime field in dd/mm/yyyy format. By the way, I'm restricted to returning 2 columns of data, hence the select statement format.
Thanks for any help.