Convert DateTime value to String in MySql Database

zzz
 
on Jul 03, 2015 03:57 AM
4635 Views

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

Download FREE API for Word, Excel and PDF in ASP.Net: Download
Mudassar
 
on Jul 05, 2015 11:30 PM
on Jul 06, 2015 12:07 AM

Refer

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