SELECT i.id, CONVERT(varchar(30),i.startdate,101)
, i.duration, i.id_location
FROM instance i, location l
WHERE #course_id# = l.id_course
AND i.id_location = l.id


You can try other format styles too besides 101. See books online for other options.