Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Format Date doesn't display month as upper case

Received Response
671
Views
22
Comments
13»

Answers

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics & AI Lead

    Thas good if u think u find a solution for this close the thread so that it will be useful for other when searching

  • Swapna Kankipati
    Swapna Kankipati Rank 2 - Community Beginner

    I was able to achieve the desired result by formatting in the sql query using to_char(date_allocated, 'MON-YY') fiscal_period and the excel shows in the desired format e.g., FEB-18