public function HandlerBase::getSQLDateField

Creates cross-database SQL dates.

Return value

string An appropriate SQL string for the db type and field type.

File

drupal/core/modules/views/lib/Drupal/views/Plugin/views/HandlerBase.php, line 710

Definition of Drupal\views\Plugin\views\HandlerBase.

Class

HandlerBase

Namespace

Code

public function getSQLDateField() {
  $field = "{$this->tableAlias}.{$this->realField}";
  $db_type = Database::getConnection()
    ->databaseType();
  $offset = $this
    ->getTimezone();
  if (isset($offset) && !is_numeric($offset)) {
    $dtz = new \DateTimeZone($offset);
    $dt = new \DateTime('now', $dtz);
    $offset_seconds = $dtz
      ->getOffset($dt);
  }
  switch ($db_type) {
    case 'mysql':
      $field = "DATE_ADD('19700101', INTERVAL {$field} SECOND)";
      if (!empty($offset)) {
        $field = "({$field} + INTERVAL {$offset_seconds} SECOND)";
      }
      return $field;
    case 'pgsql':
      $field = "TO_TIMESTAMP({$field})";
      if (!empty($offset)) {
        $field = "({$field} + INTERVAL '{$offset_seconds} SECONDS')";
      }
      return $field;
    case 'sqlite':
      if (!empty($offset)) {
        $field = "({$field} + '{$offset_seconds}')";
      }
      return $field;
  }
}