function date_sql_handler::db_tz_support in Date 6

Same name and namespace in other branches

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

See if the db has timezone name support.

1 call to date_sql_handler::db_tz_support()

date_sql_handler::sql_tz in ./date_api_sql.inc

Select a date value from the database, adjusting the value for the timezone.

File

./date_api_sql.inc, line 64

Class

date_sql_handler

A class to manipulate date SQL.

Code

function db_tz_support($reset = FALSE) {
  $has_support = variable_get('date_db_tz_support', -1);
  if ($has_support == -1 || $reset) {
    date_api_set_db_timezone();
    $has_support = FALSE;
    switch ($this->db_type) {
      case 'mysql':
      case 'mysqli':
        $test = db_result(db_query("SELECT CONVERT_TZ('2008-02-15 12:00:00', 'UTC', 'US/Central')"));
        if ($test == '2008-02-15 06:00:00') {
          $has_support = TRUE;
        }
        break;
      case 'pgsql':
        $test = "TIMESTAMP WITH TIME ZONE '2008-02-15 12:00:00' AT TIME ZONE 'US/Central'";
        if ($test == '2008-02-15 06:00:00') {
          $has_support = TRUE;
        }
        break;
    }
    variable_set('date_db_tz_support', $has_support);
  }
  return $has_support;
}