4 Replies Latest reply: Nov 1, 2012 2:52 PM by jameshuk RSS

    Month function in Script

      Hi:

       

      Full disclosure I'm not a QV developer, just playing one on TV.

      Trying to load several fields from and Oracle DB and in the process create a new Month and Year field based upon a timestamp field that is coming in.

       

      Currently have:

       

      DETL: 

      SQL SELECT

      ID,

      CREATE_DATE,

      MONTH (CREATE_DATE) as CREATEMONTH;

       

      And get:

       

       

       

      ErrorSource: OraOLEDB, ErrorMsg: ORA-00904: "MONTH": invalid identifier

       

      Can I do this or am I just doing somethign stupid?

       

      Thanks in advance,

      Jim