Oracle timestamp in qlikview

manideep78 — Sat, 16 Nov 2024 01:38:03 GMT

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.

Re: Oracle timestamp in qlikview

Taoufiq_Zarra — Tue, 24 Dec 2019 20:55:16 GMT

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, ...

topic Re: Oracle timestamp in qlikview in QlikView

Oracle timestamp in qlikview

Re: Oracle timestamp in qlikview