Oracle date/timezone issues

Mon, 26 Jan 2026 18:19:17 GMT

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.

topic Oracle date/timezone issues in QlikView

Oracle date/timezone issues