I've got a Twitter database and some columns in multiple tables are time-stamps like:
Tue Sep 09 23:48:37 +0000 2014
These columns are
TEXT so I want to convert them. I read
Date and Time Types,
STR_TO_DATE. It seems like that there's no symbol to recognize the timezone pattern, and I can't ignore it because it's not at the end of the string therefore
STR_TO_DATE can't leave it there.
Is there some function or walk-around to deal with this problem? Thanks a lot!