如何在mysql的时间数据类型字段中插入am pm？

Question

I need to save a library all 7 days 'open time' and 'close time' , Please suggest how to achieve this?

Currently I have create a database table_lib_hours

-----FIELD-----|--TYPE-------
|day_id        | int(10)     |
|day_name      |varchar(100) |
|day_open_time |TIME         |
|day_close_time|TIME         | 
|last_update   |TIMESTAMP    |

Now my question is

Is there any way to store all 7 day's name in day_name field automatically ?

Answer 1

Use a timestamp in UTC timezone for easier relocation of the server.

In your application, simple format the timestamp for output. When reading in data, use gmmktime().