string_to_date Help

[Derek Meyer]

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