Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ananyaghosh
Contributor III

Oracle timestamp value is changed at Qlik sense side

Hi,

My data source is Oracle and Datatype is Timestamp.

My value at oracle field is: '11-AUG-18 08:38:01.000000000 PM'

When I use your expression the value is changed to: 12-08-2018  06:08:01 AM.

It is noted that I am using the below expression:

Timestamp(UNPACKAGED_DATE_TIME, 'MM/DD/YYYY h:mm:ss.fff TT') as UNPACKAGED_DATE_TIME

and my sql is:

select FILE_ID, UNPACKAGED_DATE_TIME

from edi_e2e_user.abc_e2e_tracking_record where FILE_ID = 'ci1534054081616.19521239@sbycsaxy05_te';

Please advise what should I do now?

6 Replies
arvind1494
Valued Contributor

Re: Oracle timestamp value is changed at Qlik sense side

In main script

change SET CollationLocale='en-US';  to

SET CollationLocale='en-IN';

ananyaghosh
Contributor III

Re: Oracle timestamp value is changed at Qlik sense side

Hi,

It is not working for me. Please advise what is causing problem?

arvind1494
Valued Contributor

Re: Oracle timestamp value is changed at Qlik sense side

Can you attach your sample qvw

Re: Oracle timestamp value is changed at Qlik sense side

Does this helps?

=Timestamp(Timestamp#(UNPACKAGED_DATE_TIME,'DD-MMM-YY hh:mm:ss.fffffffff TT'), 'DD-MMM-YY h:mm:ss') & '.' & SubField(SubField(UNPACKAGED_DATE_TIME,' ',-2),'.',-1) & ' ' & SubField(UNPACKAGED_DATE_TIME,' ',-1)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
balabhaskarqlik
Honored Contributor

Re: Oracle timestamp value is changed at Qlik sense side

May be this:

Date(Floor(TimeStamp#(DateField))) as Date

Support
Support

Re: Oracle timestamp value is changed at Qlik sense side

Try loading UNPACKAGED_DATE_TIME as text. Which textual value of this field shows up in the raw data?

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.