title: Change date format to 'DD-MON-YYYY' in OBIEE
body: <p>i have a variable prompt using a sql query. this quesry gives the previous month end date.</p>
  
  <p>SELECT TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(CURRENT_DATE) * -1 , CURRENT_DATE) s_1 FROM "FDM DDR"</p>
  
  <p>query displays output in format dd/mm/yyyy. </p>
  
  <p>this date output is an input to a ddr query. The ddr query fails because oracle accepts date in the format 'dd-mon-yyyy'.</p>
  
  <p>so could you please suggest how should i change above query so that it displays date in the format 'dd-mon-yyyy' instead of 'dd/mm/yyyy'.</p>
  
  <p>thanks. </p>