Classic ASP with Oracle

Question

I have a select statement which is running fine in sqlplus but when i m trying to run in Classic ASP code I am getting below error

ORA-01843: not a valid month

My Select Query is as below

SELECT YEAR_MONTH, LAST_DAY(TO_DATE(TO_DATE('201106','YYYYMM'),'MM/DD/YYYY')) AS MAX_END_DT FROM MONTH_DIM WHERE '04-28-2016' BETWEEN MONTH_START_DATE AND MONTH_END_DATE

ASP Code as Below
Dim rs
cmd.CommandType = adCmdText
    cmd.CommandText =  "SELECT YEAR_MONTH, LAST_DAY(TO_DATE(TO_DATE('" & MAXYEARMONTH & "','YYYYMM'),'MM/DD/YYYY')) AS MAX_END_DT FROM MONTH_DIM WHERE '" &  END_DT & "' BETWEEN MONTH_START_DATE AND MONTH_END_DATE"
    set rs = cmd.execute --here is problem

Answer 1

use TO_DATE('" & END_DT & "','MM/DD/YYYY')