SELECT STR_TO_DATE('2015-08-07T09:27:54Z','%Y-%m-%dT%TZ');