mysql毫秒转换日期时间_MySQL日期类型和毫秒值相互转换

现在，新建一张数据库表t_stu_info，并向表里插入数据

use test;

show tables;

create table t_stu_info(

id int not null primary key,

stu_name varchar(20),

stu_date timestamp,

stu_age int(3),

stu_sex varchar(5)

);

insert into t_stu_info(id,stu_name,stu_date,stu_age,stu_sex) values ('1','zhangsan','2000-12-12 12:30:00','15','man');

commit;

select * from t_stu_info;

1、日期转换成毫秒值

select UNIX_TIMESTAMP(t.stu_date) from t_stu_info t

2、毫秒值转换成日期

SELECT

FROM_UNIXTIME(UNIX_TIMESTAMP(t.stu_date),

'%Y-%m-%d %h:%i:%s') AS stu_date

FROM

t_stu_info t

SELECT

FROM_UNIXTIME(UNIX_TIMESTAMP(t.stu_date),

'%Y-%m-%d') AS stu_date

FROM

t_stu_info t

MySQL日期类型和毫秒值相互转换

标签：mysql   日期转换成毫秒值   毫秒值转换成日期

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://blog.csdn.net/you23hai45/article/details/45251373