SQL date conversion to written date

Question

Hi everyone I have a date in the format DD/MM/YYYY how do I convert it to the newDate format displayed below?

Date      |Newdate type
05/02/2017|Sunday 5 March 2017
04/02/2017|Saturday 4 March 2017

USING a SQL front end based on Microsoft jet

Answer 1

managed to find an answer

https://msdn.microsoft.com/en-us/library/ee634398.aspx

FORMAT(column,'dddd dd MMMM yyyy ')