Convert Date String to Date in MySQL query

Question

I need some help with this. I have database with a column for start and end with a value format Fri Feb 21 2014 00:00:00 GMT+0800 (Malay Peninsula Standard Time) an store in varchar. I want to convert it to date in MySQL query.

I've tried using str_to_date() but there is no luck.

Please help me!

Abdul Manaf · Accepted Answer · 2014-02-19 06:59:53Z

1

SELECT STR_TO_DATE('Fri Feb 21 2014 00:00:00 GMT+0800 (Malay Peninsula Standard Time)','%a %M %e %Y %H:%i:%s');
+---------------------------------------------------------------------------------------------------------+
| STR_TO_DATE('Fri Feb 21 2014 00:00:00 GMT+0800 (Malay Peninsula Standard Time)','%a %M %e %Y %H:%i:%s') |
+---------------------------------------------------------------------------------------------------------+
| 2014-02-21 00:00:00                                                                                     |
+---------------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.00 sec)

answered Feb 19, 2014 at 6:59

Abdul Manaf

4,8883 gold badges29 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

shark Over a year ago

I've tried that one but using this Fri Feb 21 2014 00:00:00 GMT+0800 (Malay Peninsula Standard Time). no luck.

Abdul Manaf Over a year ago

Working for that string too. Updated my answer.

Collectives™ on Stack Overflow

Convert Date String to Date in MySQL query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related