function date_sql_handler::sql_where_extract in Date 5.2

Same name and namespace in other branches

1. 6.2 date_api_sql.inc \date_sql_handler::sql_where_extract()
2. 6 date_api_sql.inc \date_sql_handler::sql_where_extract()
3. 7.3 date_api/date_api_sql.inc \date_sql_handler::sql_where_extract()
4. 7 date_api/date_api_sql.inc \date_sql_handler::sql_where_extract()
5. 7.2 date_api/date_api_sql.inc \date_sql_handler::sql_where_extract()

Create a where clause to compare an extracted part of a field to an integer value.

Parameters

string $part: The part to extract, YEAR, MONTH, DAY, etc.

string $field: The db table and field name, like "$table.$field".

string $operator: The db comparison operator to use, like '='.

int $value: The integer value to compare the extracted date part to.

Return value

SQL for the where clause for this operation.

File

./date_api_sql.inc, line 463

Class

date_sql_handler

A class to manipulate date SQL.

Code

function sql_where_extract($part, $field, $operator, $value) {
  if ($this->local_timezone != $this->db_timezone) {
    $field = $this
      ->sql_field($field);
  }
  else {
    $field = $this
      ->sql_field($field, 0);
  }
  return $this
    ->sql_extract($part, $field) . " {$operator} {$value}";
}