SQL convert date to string in custom format : I need to SELECT a date field but export it as STRING. Not date formatted in a specific way but pure STRING. for example if I have a date 06-May-2016 I need it to be exported as "06.2016". I tried something like:
  
SELECT convert ( "Application_Date", 'MM.YYYY')  

but that's just rubbish. It seems like a simple issue but I've been searching for an answer for sometime now and nothing.