Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Problem facing while trying the convert of timestamp(YYYY-MM-DD :hh:mm:SS) into date format and get the duration of two dates .
May be using these?
Diff:
Load
Date(Date#(UPLD_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM') as Date,
Date(Date#(PROCESS_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM') as Date1,
Date(Date#(UPLD_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM-DD:hh:mm:SS') as Time
resident Time ;
May be using these?
Diff:
Load
Date(Date#(UPLD_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM') as Date,
Date(Date#(PROCESS_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM') as Date1,
Date(Date#(UPLD_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM-DD:hh:mm:SS') as Time
resident Time ;
Anil thanks,how can to get the difference of two dates i.e., duration b/w two time frames
May be this?
Date(Interval(Date-Date1),'YYYY-MM-DD:hh:mm:ss') as Date2; |
Explanation: Here, Interval works as Number after that we need to control as out requirement using Date function