MySQL将datetime转换为unixtime? [英] MySQL convert datetime to unixtime?

问题描述

我有一列具有DATETIME格式的列，我想将其转换为数据库中的UNIXTIME.那是什么样的查询?

I have a column with the DATETIME format and I would like to convert it to UNIXTIME in the database. What kind of query would that be?

我知道如何从UNIXTIME转换为DATETIME，但是我从未做过相反的事情.我用过FROM_UNIXTIME，是否没有TO_UNIXTIME?

I know how to convert from UNIXTIME to DATETIME, but I've never done the reverse. I've used FROM_UNIXTIME, is there no TO_UNIXTIME?

推荐答案

它是

It's UNIX_TIMESTAMP. This will take a properly formatted datetime as an argument.

这篇关于MySQL将datetime转换为unixtime?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！