I am confused as to how to use the Time type in inserting data in my table. Currently I have Time as the type and 17:00:00 (hours:min:sec) as the way I am entering but am unable to retrieve it as 5:00 PM.
I have tried DATE_FORMAT(%H, i%) but it does not seem to work.
The actual syntax was:
Select example.Name, example.DAY, DATE_FORMAT(example.TIME(%H,%I))
So I think I am doing everything wrong. Any help would be appreciated.