public function Sql::getDateFormat

Overrides \Drupal\views\Plugin\views\query\QueryPluginBase::getDateFormat().

Overrides QueryPluginBase::getDateFormat

File

drupal/core/modules/views/lib/Drupal/views/Plugin/views/query/Sql.php, line 1736

Definition of Drupal\views\Plugin\views\query\Sql.

Class

Sql

@todo.

Namespace

Code

public function getDateFormat($field, $format) {
  $db_type = Database::getConnection()
    ->databaseType();
  switch ($db_type) {
    case 'mysql':
      $replace = array(
        'Y' => '%Y',
        'y' => '%y',
        'M' => '%b',
        'm' => '%m',
        'n' => '%c',
        'F' => '%M',
        'D' => '%a',
        'd' => '%d',
        'l' => '%W',
        'j' => '%e',
        'W' => '%v',
        'H' => '%H',
        'h' => '%h',
        'i' => '%i',
        's' => '%s',
        'A' => '%p',
      );
      $format = strtr($format, $replace);
      return "DATE_FORMAT({$field}, '{$format}')";
    case 'pgsql':
      $replace = array(
        'Y' => 'YYYY',
        'y' => 'YY',
        'M' => 'Mon',
        'm' => 'MM',
        // No format for Numeric representation of a month, without leading
        // zeros.
        'n' => 'MM',
        'F' => 'Month',
        'D' => 'Dy',
        'd' => 'DD',
        'l' => 'Day',
        // No format for Day of the month without leading zeros.
        'j' => 'DD',
        'W' => 'WW',
        'H' => 'HH24',
        'h' => 'HH12',
        'i' => 'MI',
        's' => 'SS',
        'A' => 'AM',
      );
      $format = strtr($format, $replace);
      return "TO_CHAR({$field}, '{$format}')";
    case 'sqlite':
      $replace = array(
        'Y' => '%Y',
        // No format for 2 digit year number.
        'y' => '%Y',
        // No format for 3 letter month name.
        'M' => '%m',
        'm' => '%m',
        // No format for month number without leading zeros.
        'n' => '%m',
        // No format for full month name.
        'F' => '%m',
        // No format for 3 letter day name.
        'D' => '%d',
        'd' => '%d',
        // No format for full day name.
        'l' => '%d',
        // no format for day of month number without leading zeros.
        'j' => '%d',
        'W' => '%W',
        'H' => '%H',
        // No format for 12 hour hour with leading zeros.
        'h' => '%H',
        'i' => '%M',
        's' => '%S',
        // No format for AM/PM.
        'A' => '',
      );
      $format = strtr($format, $replace);
      return "strftime('{$format}', {$field}, 'unixepoch')";
  }
}