如何在mysql中将字符串转换为日期? [英] how to convert a string to date in mysql?
问题描述
我有一个字符串
列作为日期
,我想选择它作为 date
。
I have a string
column which acts as a date
and I want to select it as a date
.
可以吗?
我的样本数据格式为月/日/年
- > 12/31/2011
My sample data format would be; month/day/year
-> 12/31/2011
推荐答案
正如这里所说 MySQL使用带有日期文本的字符串列作为日期字段,您可以执行
As was told here MySQL Using a string column with date text as a date field , you can do
SELECT STR_TO_DATE(yourdatefield, '%m/%d/%Y')
FROM yourtable
您还可以在WHERE子句中处理这些日期字符串。例如
You can also handle these date strings in WHERE clauses. For example
SELECT whatever
FROM yourtable
WHERE STR_TO_DATE(yourdatefield, '%m/%d/%Y') > CURDATE() - INTERVAL 7 DAYS
这样可以处理各种日期/时间布局。请参阅 DATE_FORMAT()
函数的格式说明符,以查看可以将第二个参数放入 STR_TO_DATE()
You can handle all kinds of date / time layouts this way. Please refer to the format specifiers for the DATE_FORMAT()
function to see what you can put into the second parameter to STR_TO_DATE()
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format
这篇关于如何在mysql中将字符串转换为日期?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!