home User Guide Getting Started Help Center Documentation Community Training Certification
Looker keyboard_arrow_down
language keyboard_arrow_down


view: view_name {
  dimension: field_name {
    convert_tz: yes | no



Possible Field Types

Dimension, Dimension Group, Measure, Filter, Parameter


A Boolean (yes or no)


Looker has various time zone settings that convert time-based data between different time zones. Looker does time zone conversion by default. If you do not want Looker to perform a time zone conversion for a particular dimension, dimension_group (with type: time), or filter field, then you can use the convert_tz parameter. This can be useful for fields that are already converted to the appropriate time zone, or in some advanced situations where you need to avoid a double time zone conversion.

In general, time computations (differences, durations, etc.) only work correctly when you operate on time values that are all converted to the same time zone, so it is important to keep time zones in mind when writing LookML.


Do not perform time zone conversion for the local_created dimension group:

dimension_group: local_created { type: time timeframes: [time, date, week, month] sql: ${TABLE}.local_created_at ;; convert_tz: no }

Things to Consider

convert_tz: no applies only to a dimension, not to a filter that uses the dimension. In other words, filters always perform time zone conversion. When you specify convert_tz: no, time-based data values are displayed in the database time zone, but are filtered using the query time zone.

Because filters always do time zone conversion, a difference between the database time zone and query time zone could cause data to unexpectedly be included or excluded from a dataset. To avoid this, ensure that the query time zone is set to the same value as the database time zone.

If User Specific Time Zones is enabled, set the time zone drop-down menu (located next to the Run button on Explores, Looks, and dashboards) to the same value as the database time zone. If User Specific Time Zones is disabled, set the Query Time Zone to the same value as the database time zone.

Database Dialect Support for Time Zone Conversion

Looker’s ability to convert time zones depends on each database dialect’s support of this functionality. The list below shows which dialects support time zone conversion in the most recent Looker release.