STR_TO_DATE函数在mysql中返回null

Question

SELECT STR_TO_DATE(LEFT(booking_date , 10), '%c/%e/%Y') from mycase 

booking_date是我的字段，包含01-10-2015 Evening（3PM - 6PM）之类的数据。

我想先获取日期，然后我想在MySQL中将其转换为日期类型。

Answer 1

您需要更改/到-在str_to_time功能，因为您输入日期的格式为01-10-2015

mysql> SELECT STR_TO_DATE(LEFT('01-10-2015 Evening (3PM - 6PM)' , 10), '%c-%e-%Y') as d ; 
+------------+ 
| d   | 
+------------+ 
| 2015-01-10 | 
+------------+ 

SELECT STR_TO_DATE(LEFT(booking_date , 10), '%c-%e-%Y') from mycase