Oracle timestamp in qlikview

[manideep78]

Dear Community,

I have timestamp  09-DEC-19 02.03.28.604711000 PM  coming from Oracle into Qlikview and it is a string.

I could not covert that into qlikview timestamp format using Timestamp#. 

Any suggestions welcome.

[Taoufiq_Zarra]

if that doesn't work, you can always use the hard methods 😁

=TimeStamp(Time#(left(Right(('09-DEC-19 02.03.28.604711000 PM'),21),8)&' '&Right(Right(('09-DEC-19 02.03.28.604711000 PM'),21),2),'hh.mm.ss TT')+ Date#(left(('09-DEC-19 02.03.28.604711000 PM'),9),'DD-MMM-YY'), 'DD/MM/YYYY hh:mm:ss')

you can get results like :

which you can use as a TimeStamp, i.e. you can extract the hour, minutes, ...