function views_handler_field_datetime::query in MERCI (Manage Equipment Reservations, Checkout and Inventory) 7.2

Same name and namespace in other branches

1. 6.2 handlers/views_handler_field_date.inc \views_handler_field_datetime::query()
2. 6 handlers/views_handler_field_date.inc \views_handler_field_datetime::query()

Called to add the field to a query.

Overrides views_handler_field::query

File

handlers/views_handler_field_date.inc, line 14

merci views handlers

Class

views_handler_field_datetime

Views assumes dates are always Unix timestamps, so convert our DATETIME-formatted columns.

Code

function query() {
  $this
    ->ensure_my_table();
  $this->field_alias = $this->query
    ->add_field(NULL, 'UNIX_TIMESTAMP(' . $this->table_alias . '.' . $this->field . ')', $this->table_alias . '_' . $this->field);
}