7 Replies Latest reply: Oct 5, 2015 6:07 AM by Sifat Rahman RSS

    Oracle SQL query works in SQL Developer but not QlikView

    Sifat Rahman

      Hi all,

       

      On Oracle SQL Developer, this query runs successfully:

       

      select * from table

      where msg_date_time BETWEEN to_timestamp(to_date('23-SEP-15', 'DD-MON-YY') || ' 05:00:00', 'DD-MON-YY hh24:mi:ss')

                              AND to_timestamp(to_date('23-SEP-15', 'DD-MON-YY') || ' 18:00:00', 'DD-MON-YY hh24:mi:ss')

       

      But when I put this in the QlikView script, I get a "Not a valid month" error. Any ideas on why this would happen?