I try to insert times into my database.
I created a time field in a table and want to enter AM/PM time into it.
"insert into test(time) values('10:00:00 PM');"
After that I want to view my table:
"select time_format(time, '%r') from test;"
I get this time (10:00:00) not as PM but always as AM. But I want it as PM in my DB.
How can I insert AM/PM time directly?
Problems by inserting time AM and PM
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users