How do I convert an integer that is stored in a varchar table to hour and minute?
The data is saved in MySQL in this way example: 1030
and I need to show it as 10:30 am
.
Can a conversion be done in PHP or from MySQL?
How do I convert an integer that is stored in a varchar table to hour and minute?
The data is saved in MySQL in this way example: 1030
and I need to show it as 10:30 am
.
Can a conversion be done in PHP or from MySQL?