Prevent Automatic TO_CHAR()

[PaulM1]

Using Snowflake backend.

I’ve got a dimension like this:

  dimension: orderdate_ntz_param_tz_offset {
    type: date_time
    convert_tz: no
    datatype: date
    sql: DATEADD(HOUR, {% parameter p_TimeZoneOffset_Hours %},DATEADD(MINUTE, {% parameter p_TimeZoneOffset_Minutes %}, ${TABLE}."ORDERDATE_NTZ")) ;;
  }

The resulting SQL always ends up being nested in a TO_CHAR():

TO_CHAR(DATEADD(HOUR, '2',DATEADD(MINUTE, '0', v_orders_f."ORDERDATE_NTZ")) , 'YYYY-MM-DD HH24:MI:SS') AS "v_orders_f.orderdate_ntz_param_tz_offset"

Is there anyway to prevent this?

[moebe]

you could use a seperate DIM_TIME/DATE Table with this logic. Then Join your OERDERDATE_NTZ with this table. Then you should not see this problem anymore

[YCZHU]

I encounter the same issue.
Why TO_CHAR() is added? what is it for? What is the side effect if I remove it?