Test - Quarry

SQL

SELECT img_name,
	CASE WHEN REGEXP_SUBSTR(img_metadata,'("DateTimeOriginal":)')!=""
    THEN SUBSTR(REGEXP_SUBSTR(img_metadata,'("DateTimeOriginal":(.*?[^[\\\\])")'), 21, 19)
    WHEN REGEXP_SUBSTR(img_metadata,'(s:8:"DateTime";s:19:")')!=""
    THEN SUBSTR(REGEXP_SUBSTR(img_metadata,'(s:8:"DateTime";s:19:"(.*?[^[\\\\])")'), 22, 19) 
    WHEN REGEXP_SUBSTR(img_metadata,'(s:16:"DateTimeOriginal";s:19:")')!=""
    THEN SUBSTR(REGEXP_SUBSTR(img_metadata,'(s:16:"DateTimeOriginal";s:19:"(.*?[^[\\\\])")'), 31, 19) 
    WHEN REGEXP_SUBSTR(img_metadata,'("DateTimeDigitized":)')!=""
    THEN SUBSTR(REGEXP_SUBSTR(img_metadata,'("DateTimeDigitized":(.*?[^[\\\\])")'), 22, 19)
    ELSE "" 
    END  as Zeit,
    
    img_metadata
FROM image
WHERE img_metadata != ""
LIMIT 1000;
SQL

Checking query status...
