如何在MySQL中轉(zhuǎn)換字符串到日期？我有一個(gè)string列，用作date我想選擇它作為date.有可能嗎？我的樣本數(shù)據(jù)格式是；month/day/year -> 12/31/2011
3 回答
慕后森
TA貢獻(xiàn)1802條經(jīng)驗(yàn) 獲得超5個(gè)贊
SELECT STR_TO_DATE(yourdatefield, '%m/%d/%Y')FROM yourtable
WHERE
SELECT whatever FROM yourtable WHERE STR_TO_DATE(yourdatefield, '%m/%d/%Y') > CURDATE() - INTERVAL 7 DAYS
DATE_FORMAT()STR_TO_DATE().
添加回答
舉報(bào)
0/150
提交
取消