Timezone conversion for a specific dimension

Jharna
Participant I

Hi,

My Database timezone is set to UTC. I use mysql. The database version is MySQL 5.7.

In one of the reports, I want the timezone to be considered as EST.

What I thought was to create separate dimension group “timestamp_EST” and add the timezone conversion in this dimension_group:

Example:

dimension_group: timestamp_EST {

type: time

timeframes: { [

     raw,
      time,
      minute,
      hour,

      date,
      week,
      month,
      quarter,
      year
    ]
    sql:  ${TABLE}.timestamp ;;
  }

But how do I add in timezone here?

Any kind of help is appreciated.

Thank you.

0 0 260
0 REPLIES 0
Top Labels in this Space
Top Solution Authors