Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
In main script
change SET CollationLocale='en-US'; to
SET CollationLocale='en-IN';
Hi,
It is not working for me. Please advise what is causing problem?
Can you attach your sample qvw
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)
May be this:
Date(Floor(TimeStamp#(DateField))) as Date
Try loading UNPACKAGED_DATE_TIME as text. Which textual value of this field shows up in the raw data?