Query Time Zone for Date Dimension being Converted Twice

[myquan]

Issue:

I am leveraging Query Time Zone connection settings and my ‘Date’ dimension is being converted twice.  Has anyone else encountered this?  See below for details.

Connection Settings:

My time zone connection settings are set  as follows:

Database Time Zone: UTC

Query Time Zone: US Eastern (America - New York)

My Date Dimension is set up as follows: (Note, I am purposely not using a dimension_group)

  dimension: placed_date {
    type:  date
    sql:  ${created_datetime_date} ;;
    label: "Date"
    group_label: " Order Date Placed"
  }

The Looker  SQL for ‘Date’ when running a basic query is ad foilows:

 (DATE(CONVERT_TIMEZONE('UTC', 'America/New_York', (DATE(CONVERT_TIMEZONE('UTC', 'America/New_York', created_datetime ))) ))) AS "date",

Anyone know why Looker has the convert_timezone, wrapped in another convert_timezone?  Want to confirm I am missing something.