I looked up on php.net the proper format for displaying date and time and it said to use %a to show am or pm.
I am using this command
which works just fine until I add the %a, and then that column gives all nulls.Code:time_format(`starttime`, '%h:%i ') as time
Why does this not work?
If %a is wrong, how do you display am and pm??Code:time_format(`starttime`, '%h:%i %a') as time