Skip to main content
When set to false, the field will default to the connection (database) timezone with no conversion. This parameter can only be added to a dimension and will apply to all the parameterizations of the dimension. Date or week fields in the database are good candidates for this parameter, as converting the time segments isn’t necessary.
Timezone conversion in a sql parameter is strongly discouraged. This approach can create challenges on SQL generation for complex transformations, such as dimension fill vis-a-vis timezones.

​
Syntax

<dimension_name>:
  convert_tz: false

​
Properties

​
dimension_name
object
The name of the dimension. Dimension names must:
  • Be unique within the view
  • Start with a letter
  • Contain only alphanumeric characters and underscores

​
Examples

Disable timezone conversion
created_date:
  sql: created_date
  convert_tz: false
Date field with timeframes
timestamp_created_pst:
  sql: DATETIME(${marketing_orders_new.timestamp_created}, 'America/Los_Angeles')
  timeframes:
    - DATE
    - HOUR_OF_DAY
    - MONTH_NAME
  convert_tz: false