public function MysqlDateSql::getDateField in Drupal 8

Same name and namespace in other branches

1. 9 core/modules/views/src/Plugin/views/query/MysqlDateSql.php \Drupal\views\Plugin\views\query\MysqlDateSql::getDateField()

Returns a native database expression for a given field.

Parameters

string $field: The query field that will be used in the expression.

bool $string_date: For certain databases, date format functions vary depending on string or numeric storage.

Return value

string An expression representing a date field with timezone.

Overrides DateSqlInterface::getDateField

File

core/modules/views/src/Plugin/views/query/MysqlDateSql.php, line 59

Class

MysqlDateSql

MySQL-specific date handling.

Namespace

Drupal\views\Plugin\views\query

Code

public function getDateField($field, $string_date) {
  if ($string_date) {
    return $field;
  }

  // Base date field storage is timestamp, so the date to be returned here is
  // epoch + stored value (seconds from epoch).
  return "DATE_ADD('19700101', INTERVAL {$field} SECOND)";
}