Timestamp convertion

[#1]

Hi,

Any one can help me to convert the below timestamp..

--> 20160223T050024.225-0800

Sub2u444‌

[#2]

You can try like below:

Timestamp#(Replace(subfield(text(timestampfield),'.',1),'T',' '),'YYYYMMDD hhmmss')

[#3]

Hi,

Its getting the value.. But i need help with the below attachment to show only latest record based on region...

Sub2u444

[#4]

Try like below:

Source:

LOAD

     *,

     Timestamp(Timestamp#(Replace(subfield(text(timestampfield),'.',1),'T',' '),'YYYYMMDD hhmmss')) as new_ts

From file;

Inner Join,

Load

     TaskName,

     Timestamp(Max(new_ts)) as new_ts

Resident Source

Group by TaskName

;

[settu_periasamy]

Check here also..

Re: Logfile Dashboard Report

[Digvijay_Singh]

See if attached can help -

Load *,

  num#(Timestamp#(Date + Time)) as FinalTimestamp;

Load *,

  Date(date#(SubField(Timestamp,'T',1),'YYYYMMDD'),'DDMMYYYY') as Date,

  maketime(Mid(Timestamp,10,2),Mid(Timestamp,12,2),Mid(Timestamp,14,6)) as Time;

Load * inline [

Timestamp, Region

20160223T090024.495-0800, Japan

20160223T110023.494-0800, Japan

20160223T130026.273-0800, Japan

20160223T150028.306-0800, Japan

];