How to filter Date Views with correctly timezone
Ok, I made it working.
My solution is created a custom drupal 8 module with the file: .views_execution.inc inside your module folder.

Inside that, I added function modulename_views_query_alter($view, $query) with:

//Filter by timezone for bettingsafe's local ip
switch ($view-&gt;element['#name']){
    case 'league_match':
        $key = 0;
        foreach ($query-&gt;where as $key =&gt; $value){
            $key_2 = 0;
            foreach ($value['conditions'] as $key2 =&gt; $condition){
                $length = strlen('DATE_FORMAT');
                if (substr($condition['field'], 0, $length) === 'DATE_FORMAT'){
                    $condition['field'] = str_replace('DATE_FORMAT(&lt;date field&gt;', 'DATE_FORMAT(CONVERT_TZ(&lt;date field&gt;, &lt;from timezone&gt;, &lt;to timezone&gt;')', $condition['field']);                        
                    $query-&gt;where[$key]['conditions'][$key_2]['field'] = $condition['field'];
                }
                $key_2+=1;
            }
            $key+=1;
        }
    break;
}


From my server Centos, I install the tool CONVERT_TZ:

shell&gt; mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p&lt;sql root's password&gt;


Restart mysqld and clear Drupal cache.

Hope that's will help someone.