1 Reply Latest reply: Feb 10, 2010 9:35 PM by Rob Wunderlich RSS

    Date format issue

      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";