MySQL将datetime转换为Unix时间戳 [英] MySQL convert datetime to Unix timestamp
本文介绍了MySQL将datetime转换为Unix时间戳的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何将以下格式转换为unix时间戳?
How do I convert the following format to unix timestamp?
Apr 15 2012 12:00AM
从DB获取的格式似乎在最后有 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
This Query for 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将datetime转换为Unix时间戳的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文