mysql如何将varchar(10)转换为TIMESTAMP? [英] mysql how to convert varchar(10) to TIMESTAMP?

问题描述

我将所有日期存储为varchar(10)到我的数据库中，现在我想将它们转换成TIMESTAMP.

I have stored all the date into my database as varchar(10), now I want to converse them into TIMESTAMP.

当我运行sql

ALTER TABLE  `demo3` CHANGE  `date`  `date` TIMESTAMP NOT NULL

它的警报:

#1292 - Incorrect datetime value: '1320534000' for column 'date' at row 1 

顺便说一句，我所有的约会日期都是10位数字.

BTW, All my date formart are 10 digital number.

推荐答案

您应先将时间戳记更改为datetime，然后才能更改列的类型.

You should first change the timestamp to datetime and then can change the type of column.

ALTER TABLE `demo3` MODIFY COLUMN `date` varchar(25);

UPDATE `demo3` SET `date`= FROM_UNIXTIME(`date`);

ALTER TABLE  `demo3` CHANGE  `date`  `date` TIMESTAMP NOT NULL

这篇关于mysql如何将varchar(10)转换为TIMESTAMP?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！