public function PostgresqlDateSql::setTimezoneOffset in Drupal 8

Same name and namespace in other branches

1. 9 core/modules/views/src/Plugin/views/query/PostgresqlDateSql.php \Drupal\views\Plugin\views\query\PostgresqlDateSql::setTimezoneOffset()
2. 10 core/modules/views/src/Plugin/views/query/PostgresqlDateSql.php \Drupal\views\Plugin\views\query\PostgresqlDateSql::setTimezoneOffset()

Set the database to the given timezone.

Parameters

string $offset: The timezone.

Overrides DateSqlInterface::setTimezoneOffset

File

core/modules/views/src/Plugin/views/query/PostgresqlDateSql.php, line 92

Class

PostgresqlDateSql

PostgreSQL-specific date handling.

Namespace

Drupal\views\Plugin\views\query

Code

public function setTimezoneOffset($offset) {
  $this->database
    ->query("SET TIME ZONE INTERVAL '{$offset}' HOUR TO MINUTE");
}