MySQL Forums
Forum List  »  Newbie

string_to_date Help
Posted by: Derek Meyer
Date: August 17, 2017 08:27AM

I'm having a bit of a issue converting this... AWS decided to use a weird format for some of the alerts they have

'Fri, 4 Aug 2017 16:57:27 PDT' is what they have

I have tried a couple of iterations of
SELECT
str_to_date('Fri, 29 Jul 2016 19:12:00','%a, %D %b %Y %H:%i:%s') as a

I am thinking the PDT and the , are partially screwing it up

Best guess on how to account for this in sql?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
string_to_date Help
August 17, 2017 08:27AM
August 17, 2017 09:03AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.