Every major sql database has a different way to handle dates in sql, see http://api.drupal.org/api/views/includes%21handlers.inc/function/views_d... for a hacky workaround.
Drupal 8 will hopefully get a proper date component, see #1802278: Add a Date component to core
but it would be also very helpful to have some handling of date sql, which can be overridden by the different database drivers.
Comments
Comment #7
jibranWe have
\Drupal\views\Plugin\views\query\DateSqlInterface::getDateFormat()in core since #2627512: Datetime Views plugins don't support timezones now which as all the implementation for all the DB drivers.