WP_Date_Query::get_sql_clauses() WordPress Method

The WP_Date_Query::get_sql_clauses() method is used to return the SQL clauses for a given date query. This is useful for customizing how dates are queried in WordPress.

WP_Date_Query::get_sql_clauses() #

Generate SQL clauses to be appended to a main query.


Description

Called by the public WP_Date_Query::get_sql(), this method is abstracted out to maintain parity with the other Query classes.


Top ↑

Return

(string[]) Array containing JOIN and WHERE SQL clauses to append to the main query.

  • 'join'
    (string) SQL fragment to append to the main JOIN clause.
  • 'where'
    (string) SQL fragment to append to the main WHERE clause.


Top ↑

Source

File: wp-includes/class-wp-date-query.php

	protected function get_sql_clauses() {
		$sql = $this->get_sql_for_query( $this->queries );

		if ( ! empty( $sql['where'] ) ) {
			$sql['where'] = ' AND ' . $sql['where'];
		}

		return $sql;
	}


Top ↑

Changelog

Changelog
VersionDescription
4.1.0Introduced.

The content displayed on this page has been created in part by processing WordPress source code files which are made available under the GPLv2 (or a later version) license by theĀ Free Software Foundation. In addition to this, the content includes user-written examples and information. All material is subject to review and curation by the WPPaste.com community.