By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test (request json)
insert into test values ('{ "date_event" : "07-12-2016 18:21:59"} ')
SELECT STR_TO_DATE(JSON_UNQUOTE(JSON_EXTRACT(request, "$.date_event")), '%d-%m-%Y %H:%i:%S')
FROM test
| STR_TO_DATE(JSON_UNQUOTE(JSON_EXTRACT(request, "$.date_event")), '%d-%m-%Y %H:%i:%S') |
|---|
| 2016-12-07 18:21:59 |
SELECT STR_TO_DATE(request->>'$.date_event', '%d-%m-%Y %H:%i:%S')
FROM test
| STR_TO_DATE(request->>'$.date_event', '%d-%m-%Y %H:%i:%S') |
|---|
| 2016-12-07 18:21:59 |
SELECT STR_TO_DATE(JSON_EXTRACT(request, "$.date_event"),'"%d-%m-%Y %H:%i:%S"')
FROM test
| STR_TO_DATE(JSON_EXTRACT(request, "$.date_event"),'"%d-%m-%Y %H:%i:%S"') |
|---|
| 2016-12-07 18:21:59 |