Joey Newsom asked 10 years ago
I have a DB field called 'time' which is an integer field containing seconds… (minutes and seconds were converted to seconds for easier sorting of 'time' field)
In my GRID, I need to convert the time back to minutes and seconds in the format MM:SS.
Any suggestions?
Joey
1 Answers
Abu Ghufran answered 10 years ago
You can use mysql date_format function in sql, and get desired format in grid.
Even if you want to do this conversion at application level, you can refer on_data_display event handler (demos/editing/custom-events.php)
Your Answer
