Date format in mysql
Posted by: Fazil Fazil
Date: March 01, 2018 10:37PM

Hi All,

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


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.


Options: ReplyQuote

Written By
Date format in mysql
March 01, 2018 10:37PM
March 03, 2018 06:54PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.