Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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, ...