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
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?


Options: ReplyQuote

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

Sorry, you can't reply to this topic. It has been closed.

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.