MySql，将日期和时间列组合成时间戳 [英] MySql, combining date and time column into a time stamp

问题描述

我猜这相对简单，但我不确定语法.我有要合并到时间戳列的日期和时间列.我将如何使用 select 查询这个?

I am guessing this is relatively simple to do, but I am unsure of the syntax. I have date and time columns that I want to combine to a timestamp column. how would I query this using a select?

推荐答案

Mysql好像没有datetime('2017-10-26', '09:28:00')这样的datetime构造函数.因此，您必须将组件部分视为字符串并使用字符串连接函数(注意 mysql 没有用于字符串连接的 || 运算符).如果您想要 datetime 类型，则必须强制转换它.

Mysql does not seem to have a constructor for datetime such as datetime('2017-10-26', '09:28:00'). So you will have to treat the component part as string and use string concatenation function (Note mysql does not have the || operator for string concatenation). If you want the datetime type, you will have to cast it.

concat(datefield,' ',timefield) as date

select cast(concat('2017-10-26', ' ', '09:28:00') as datetime) as dt;

这篇关于MySql，将日期和时间列组合成时间戳的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！