Michael Olson asked 8 months ago
I would like to format a time field that is stored in MySQL table to display such as 2:35 pm instead of 14:35:00
I cannot get any of the datetime examples to work.
3 Answers
Cedric answered 8 months ago
Hello, you should be able to use the mysql command to format it the way you want.
What type is the mysql field? Datetime? if yes you should be able to use somethins like this:
SELECT *, DATE_FORMAT(urdatefield, "%d/%m/%Y %r") FROM yourtable;
Michael Olson answered 8 months ago
It is a time field. Not datetime. But when editing the time I want the user to be able to enter it as am or pm.
Michael Olson answered 8 months ago
Any more help on this one? I know that when I pull the data from the server I can display it by formatting it in the select. What I am asking about is when using the grid add or edit function how I can allow the user to put in a time such as “2:02 pm” instead of 14:02
Your Answer
