Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Convert Engine DateTime Stamp

Does anyone have a function or an expression to translate the DateTimeStamp in a log file to an actual date and time?

1 Solution

Accepted Solutions
rittermd
Master
Master
Author

I actually found this on another post and it worked great

Date(Timestamp(Today()),'DD/MM/YYYY hh:mm:ss')

View solution in original post

3 Replies
swuehl
MVP
MVP

You would probably use Timestamp#() function (with an appropriate format code and / or additional string functions) to interprete the timestamp values.

Get the Dates Right

Why don’t my dates work?

surendraj
Specialist
Specialist

Hi,

when we are tring to pull the log file it will be like

2.png

here in script

tab1:

LOAD @1

FROM

(txt, unicode, no labels, delimiter is '\t', msq);

load date(SubField(@1,' ',1)) as date

resident tab1;

5.png

By this i got the time in application...

--surendra

rittermd
Master
Master
Author

I actually found this on another post and it worked great

Date(Timestamp(Today()),'DD/MM/YYYY hh:mm:ss')