How to add hours to my timeframe field?

[mohiit_jain3]

I have a dimension group like this--

dimension_group: timestamp{
    type: time
    description: "day-month-year time of leave"
    timeframes: [
      raw,
      day_of_week,
      time,
      date,
      week,
      month,
      quarter,
      year
    ]
    sql: ${TABLE}."timestamp" ;;
  }

I am trying to create a new field out of this where I get +8 hours with this timestamp field, something like this--

dimension_group: timestamp+8hours{
    type: time
    description: "day-month-year time of leave"
    timeframes: [
      raw+8hours,
      day_of_week+8hours,
      time+8hours,
      date+8hours,
      week+8hours,
      month+8hours,
      quarter+8hours,
      year+8hours
    ]
    sql: ${TABLE}."timestamp" ;;
  }

basically, every time frame(date, time etc) will be increased by 8 hours!

example:   2021/03/2120:00:00 + 8 hours = 2021/03/22 04:00:00