Max(Timestamp) help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have a Timestamp field like below format which is extracted from Data base.

Please help me to calculate Max(TIME) In below format which is useful to apply  incremental load on this field.

[agigliotti]

what you get with Max(TIME) in a text box ?

[ChennaiahNallani]

try like below

DBSCRIPT:

Load

AppName,

StreamName,

TIME,

DATE,

ENVIRONAMENT;

select

AppName,

StreamName,

TIME,

DATE,

ENVIRONAMENT FROM  "CONTOL_PROCESSING";

Temp:

load

Max(TIME) as Max_Time,

Min(TIME) as Min_Time

resident DBSCRIPT;

let vMaxDate = Num(peek('Max_Time',0,'Temp'))

[d_prashanthredd · Accepted solution]

Hi Mahitha,

try this for max date upto 6 ms precission... max(timestamp(Date, 'YYYY/M/DD hh:mm:ss.ffffff'))

Regards,

Prashanth Reddy D.

[Vamsi0529]

Hi Team,

Need small help,

I getting data from bata base, and when i check the date field i am getting below format.

When i change the format the Seconds not showing it's all 00 00 00 000

Changing format

I am getting seconds value null