The DatabaseConnection class has added several new methods and abstract methods:

abstract public function hasTimezoneSupport();

abstract public function dateFieldSql($field, $date_type = DATE_UNIX);

abstract public function dateMathSql($field, $direction, $count, $granularity);

abstract public function dateConvertTimezoneSql($field, $source, $target);

/**
 * Format a date field.
 *
 * @param string $format
 *   A format string for the result, like 'Y-m-d H:i:s' .
 * @param string $field
 *   The real table and field name, like 'tablename.fieldname' .
 *
 * @return string
 *   An appropriate SQL string for the db type and field type.
 */
abstract public function dateFormatSql($field, $format);

/**
 * Extract part of a date from a date field.
 *
 * @param string $extract_type
 *   The type of value to extract from the date, like 'MONTH'.
 * @param string $field
 *   The real table and field name, like 'tablename.fieldname'.
 *
 * @return string
 *   An appropriate SQL string for the db type and field type.
 */
abstract public function dateExtractSql($field, $extract_type);

Note: The original 1.8.0 version had different version signatures. They were updated to the signatures above in 1.8.1.

Introduced: