Title: WP_Date_Query::get_sql
Published: April 25, 2014
Last modified: February 24, 2026

---

# WP_Date_Query::get_sql(): string

## In this article

 * [Return](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#return)
 * [Source](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#source)
 * [Hooks](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#hooks)
 * [Related](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#related)
 * [Changelog](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#changelog)

[ Back to top](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#wp--skip-link--target)

Generates WHERE clause to be appended to a main query.

## 󠀁[Return](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#return)󠁿

 string MySQL WHERE clause.

## 󠀁[Source](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#source)󠁿

    ```php
    public function get_sql() {
    	$sql = $this->get_sql_clauses();

    	$where = $sql['where'];

    	/**
    	 * Filters the date query WHERE clause.
    	 *
    	 * @since 3.7.0
    	 *
    	 * @param string        $where WHERE clause of the date query.
    	 * @param WP_Date_Query $query The WP_Date_Query instance.
    	 */
    	return apply_filters( 'get_date_sql', $where, $this );
    }
    ```

[View all references](https://developer.wordpress.org/reference/files/wp-includes/class-wp-date-query.php/)
[View on Trac](https://core.trac.wordpress.org/browser/tags/6.9.4/src/wp-includes/class-wp-date-query.php#L565)
[View on GitHub](https://github.com/WordPress/wordpress-develop/blob/6.9.4/src/wp-includes/class-wp-date-query.php#L565-L579)

## 󠀁[Hooks](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#hooks)󠁿

 [apply_filters( ‘get_date_sql’, string $where, WP_Date_Query $query )](https://developer.wordpress.org/reference/hooks/get_date_sql/)

Filters the date query WHERE clause.

## 󠀁[Related](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#related)󠁿

| Uses | Description | 
| [WP_Date_Query::get_sql_clauses()](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_clauses/)`wp-includes/class-wp-date-query.php` |

Generates SQL clauses to be appended to a main query.

  | 
| [apply_filters()](https://developer.wordpress.org/reference/functions/apply_filters/)`wp-includes/plugin.php` |

Calls the callback functions that have been added to a filter hook.

  |

## 󠀁[Changelog](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql/?output_format=md#changelog)󠁿

| Version | Description | 
| [3.7.0](https://developer.wordpress.org/reference/since/3.7.0/) | Introduced. |

## User Contributed Notes

You must [log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fdeveloper.wordpress.org%2Freference%2Fclasses%2Fwp_date_query%2Fget_sql%2F)
before being able to contribute a note or feedback.