حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Convert DateTime value to String in MySql Database

zzz

I have a field that displays dd:hh:mm:ss and I want only hh:mm so theres a possible that it will result greater than 24 hours. How to do it?

For example

2:23:12:39

So it shows

2 Days

23 Hours

12 Minutes

39 Seconds

I want to make it in HH:MM only. Thank you

Mudassar

0 5

Refer

SELECT DATE_FORMAT(NOW(), '%d/%m/%Y') AS mydate;