Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
alexantone
Creator
Creator

Load date from oracle Timestamp - Qlikview

Hello

I have a problem

Qlikview cannot load data with a field like TimeStamp(6) from Oracle

This process always failed

Does anybody have an issue about this?

Type fields Field XXXX TimeStamp(6)

1 Solution

Accepted Solutions
gareth_wilson12
Partner
Partner

I think this is an issue with the OLE DB driver rather than Qlik.

In the past when I have had issues I have wrapped that field in a TO_CHAR(Your_Field) expression in the SQL query.

You can then reload or use a preceding load for Qlik to covert it back to a timestamp using TimeStamp#() function.

View solution in original post

4 Replies
jpenuliar
Partner
Partner

How are you loading in script?

Can you post your script?

alexantone
Creator
Creator
Author

Example:
SQL 
Select FieldWithTimeStamp from TABLE ;

STORE Example into $(v_qvd_path_dimensions)Example.qvd(qvd);
DROP TABLE Example;

gareth_wilson12
Partner
Partner

I think this is an issue with the OLE DB driver rather than Qlik.

In the past when I have had issues I have wrapped that field in a TO_CHAR(Your_Field) expression in the SQL query.

You can then reload or use a preceding load for Qlik to covert it back to a timestamp using TimeStamp#() function.

View solution in original post

gareth_wilson12
Partner
Partner

So you could try something like;

Example:

Load

Timestamp#(TimeField, 'DD/MM/YYYY hh:mm:ss') as Timestamp;
SQL 
Select TO_CHAR(FieldWithTimeStamp) as TimeField from TABLE ;

STORE Example into $(v_qvd_path_dimensions)Example.qvd(qvd);
DROP TABLE Example;