Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

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.

Community Browser