Date format in mysql

[Fazil Fazil]

Hi All,


I have to display the date '27 June 2015 12:12:36 PM IST'
like below

27-June-2017

How to do it

I am using below date format.But it's showing null value.

SELECT DATE_FORMAT("27 June 2015 12:12:36 PM IST", "%d-%M-%Y");


Thanks in advance.


Regards,
Abu