DateSqlInterface.php

Same filename in other branches
  1. 9 core/modules/views/src/Plugin/views/query/DateSqlInterface.php
  2. 8.9.x core/modules/views/src/Plugin/views/query/DateSqlInterface.php
  3. 11.x core/modules/views/src/Plugin/views/query/DateSqlInterface.php

Namespace

Drupal\views\Plugin\views\query

File

core/modules/views/src/Plugin/views/query/DateSqlInterface.php

View source
<?php

namespace Drupal\views\Plugin\views\query;


/**
 * Defines an interface for handling date queries with SQL.
 *
 * @internal
 *   Classes implementing this interface should only be used by the Views SQL
 *   query plugin.
 *
 * @see \Drupal\views\Plugin\views\query\Sql
 */
interface DateSqlInterface {
    
    /**
     * Returns a native database expression for a given field.
     *
     * @param string $field
     *   The query field that will be used in the expression.
     * @param bool $string_date
     *   For certain databases, date format functions vary depending on string or
     *   numeric storage.
     *
     * @return string
     *   An expression representing a date field with timezone.
     */
    public function getDateField($field, $string_date);
    
    /**
     * Creates a native database date formatting.
     *
     * @param string $field
     *   An appropriate query expression pointing to the date field.
     * @param string $format
     *   A format string for the result. For example: 'Y-m-d H:i:s'.
     *
     * @return string
     *   A string representing the field formatted as a date as specified by
     *   $format.
     */
    public function getDateFormat($field, $format);
    
    /**
     * Applies the given offset to the given field.
     *
     * @param string &$field
     *   The date field in a string format.
     * @param int $offset
     *   The timezone offset in seconds.
     */
    public function setFieldTimezoneOffset(&$field, $offset);
    
    /**
     * Set the database to the given timezone.
     *
     * @param string $offset
     *   The timezone.
     */
    public function setTimezoneOffset($offset);

}

Interfaces

Title Deprecated Summary
DateSqlInterface Defines an interface for handling date queries with SQL.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.