MySQL将日期字符串转换为Unix时间戳 [英] MySQL convert date string to Unix timestamp

问题描述

如何将以下格式转换为unix时间戳?

How do I convert the following format to unix timestamp?

Apr 15 2012 12:00AM

我从数据库获得的格式似乎最后是AM. 我尝试使用以下方法，但没有用:

The format I get from DB seems to have AM at the end. I've tried using the following but it did not work:

CONVERT(DATETIME, Sales.SalesDate, 103) AS DTSALESDATE,  
CONVERT(TIMESTAMP, Sales.SalesDate, 103) AS TSSALESDATE

where Sales.SalesDate value is Apr 15 2012 12:00AM

推荐答案

尝试对此查询CONVERT DATETIME to UNIX TIME STAMP

SELECT UNIX_TIMESTAMP(STR_TO_DATE('Apr 15 2012 12:00AM', '%M %d %Y %h:%i%p'))

此查询CHANGE DATE FORMATE

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(STR_TO_DATE('Apr 15 2012 12:00AM', '%M %d %Y %h:%i%p')),'%m-%d-%Y %h:%i:%p')

这篇关于MySQL将日期字符串转换为Unix时间戳的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！