title: Converting an integer to date in SQL
body: <p>I have a numerical column called OpenDate which displays e.g ‘16042014’ for ‘16/04/2014’ and I want to convert this into a date with the format of 16/04/2014. So when exported into excel, excel can recognise the date and filter accordingly. Currently it exports as an integer 16042014.</p>