要格式化,请使用DATE_FORMAT()。让我们先创建一个表
mysql> create table DemoTable ( LoginTime time );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable values('13:10'); mysql> insert into DemoTable values('20:08'); mysql> insert into DemoTable values('10:55'); mysql> insert into DemoTable values('16:40');
使用select语句显示表中的所有记录-
mysql> select *from DemoTable;
这将产生以下输出-
+-----------+ | LoginTime | +-----------+ | 13:10:00 | | 20:08:00 | | 10:55:00 | | 16:40:00 | +-----------+ 4 rows in set (0.00 sec)
以下是将CURRENT_TIMESTAMP格式化为AM&PM的查询-
mysql> select date_format(LoginTime,'%r') from DemoTable;
这将产生以下输出-
+-----------------------------+ | date_format(LoginTime,'%r') | +-----------------------------+ | 01:10:00 PM | | 08:08:00 PM | | 10:55:00 AM | | 04:40:00 PM | +-----------------------------+ 4 rows in set (0.00 sec)