mysql cast()函数

mysql cast()函数

值	类型	实例	结果
char(n)	字符	select cast('hello' as CHAR(2));	he
date	日期	select cast('2020-08-17 11:57:10' as date);	2020-08-17
time	时间	select cast('2020-08-17 11:57:10' as time);	11:57:10
datetime	YYYY-MM-DD HH:MM:SS	select cast('2020-08-17 11:57' as datetime);	2020-08-17 11:57:00
decimal	小数	select cast(123.4567 as decimal(10, 2));	123.45
signed	整数	select cast(123.456 as signed);	123

 

 

 

 

 

 

 

select cast(coin as decimal(10,2)) as coin from users;

select cast(created_at as date) as created_date from users;

select cast(created_at as time) as created_time from users;