I am getting raw data from an Oracle view. The view return data in MM/DD/YYYY format but when I show up this filed (ORIGINATED_MONTH) in QV graphs is shows up as mm/dd/yyyy hh:mm:ss AM. Where hh:mm:ss AM is always 12:00:00 AM.
ORIGINATED_MONTH is my dimension in the graph.
The date format is taking up space in the x-axis of the graphs, kindly suggest a setting to remove it.
I have below mentioned setting in the load script:
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
ODBC CONNECT TO [MX2RDBMS-READONLY];
SQL SELECT "EMP_DEPT_NAME",
"EMP_GEO",
NTID
FROM MX2RDBMS.USER_DATA_FOR_QV;
SQL SELECT DIVISION,
PROJECT
FROM MX2RDBMS.PROJDIVMAP;
SQL SELECT NAME,
NTID,
"ORIGINATED_DAY",
"ORIGINATED_MONTH",
PROJECT,
STATE,
YEAR,
MONTH,
QUARTER,
WEEK
FROM MX2RDBMS."ECO_FOR_QV";
