Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone have a function or an expression to translate the DateTimeStamp in a log file to an actual date and time?
I actually found this on another post and it worked great
Date(Timestamp(Today()),'DD/MM/YYYY hh:mm:ss')
You would probably use Timestamp#() function (with an appropriate format code and / or additional string functions) to interprete the timestamp values.
Hi,
when we are tring to pull the log file it will be like
here in script
tab1:
LOAD @1
FROM
(txt, unicode, no labels, delimiter is '\t', msq);
load date(SubField(@1,' ',1)) as date
resident tab1;
By this i got the time in application...
--surendra
I actually found this on another post and it worked great
Date(Timestamp(Today()),'DD/MM/YYYY hh:mm:ss')