how to store user entered time in mysql in AM/PM

Question

I need to store time which is in the form of HH: MM AM/PM which is entered from angular js front end.

HTML

<input type="time" ng-model="booktime">

Controller

$http.post("url", { 
    'booktime':booktime,
    .then(function(response) {
    },function(error) {
        alert("");
        console.error(error);
    });
}

Mysql

$sql = "INSERT INTO table(booktime)
VALUES (TIME_FORMAT( '11:00:00', '%h:%i:%s %p' ))";

Do not store am / pm, format the time in the application when you retrieve it. — Shadow, Feb 18 '17 at 10:31
MySQL DATETIME and TIME datatypes only support 24 clock you need the application to handle the am / pm.. — Raymond Nijland, Feb 18 '17 at 10:36
@user3698911 you have already found a way, it is in your question. Just use it in a select... — Shadow, Feb 18 '17 at 10:40
Possible duplicate of [javascript string to time and am/pm format](http://stackoverflow.com/questions/26835299/javascript-string-to-time-and-am-pm-format) — Shadow, Feb 18 '17 at 10:44

score -1 · Answer 1 · answered Feb 18 '17 at 11:05

You SHOULD NOT insert datetime in any other format than YYYY-MM-DD HH:MM:SS.

If you want to show to user formatted time, then do it whilst/after retrieving it from a database. For example in SELECT query:

SELECT TIME_FORMAT(booktime, '%h:%i:%s %p') AS booktime FROM table

or in your view.

how to store user entered time in mysql in AM/PM

1 Answers1