0 Replies Latest reply: Dec 20, 2011 4:49 AM by johan kristenson RSS

    Oracle date/timezone issues

      I have a query that works perfectly in oracle sql developer. But in qlikview i can only have one call per select statement to from_tz where I want to have multiple calls.

       

      ie the follwoing works:

      load *;
      sql select *, 
      from_tz(cast(END_TIME_GMT as TIMESTAMP),  'GMT') at time zone TIME_ZONE_REGION_1 as END_TIME_LOCAL 
      from FACT_TABLE;
      

      and

      load *;
      sql select *, 
      from_tz(cast(START_TIME_GMT as TIMESTAMP),  'GMT') at time zone TIME_ZONE_REGION_1 as START_TIME_LOCAL 
      from FACT_TABLE;
      

       

      but the following does not. It gives the error "execution of script failed":

      load *;
      sql select *, 
      from_tz(cast(END_TIME_GMT as TIMESTAMP),  'GMT') at time zone TIME_ZONE_REGION_1 as END_TIME_LOCAL ,
      from_tz(cast(START_TIME_GMT as TIMESTAMP),  'GMT') at time zone TIME_ZONE_REGION_1 as START_TIME_LOCAL 
      from FACT_TABLE;
      

       

      has anyone had any similar issues connecting to oracle dbs? We are using qv10 sr3 with oledb connection.