mysql将字符串从数据库转换为时间格式的wheb查询

mysql convert string to time format wheb query from database

将字段存储时间设置为varchar EX:06:30 AM。我需要从该字段中选择查询并转换为数字6.30。

对此使用TIME_FORMAT()

SELECT TIME_FORMAT( column_name, '%H.%i' ) AS time from table_name;

SELECT TIME_FORMAT(STR_TO_DATE(column_name, '%h:%i %p'),'%H.%i') from table_name;

echo date('g.i',strtotime('06:30 AM'));

g => 12-hour format of an hour without leading zeros    1 through 12
i => Minutes with leading zeros 00 to 59