Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
How to subtract this Timestamp( Start_Time - End_Time).
if any one knows this help me.
PFA for example file.
Try like:
Load
Interval(Time#(End_Time, 'hh:mm:ss TT')-Time#(Start_Time, 'hh:mm:ss TT'), 'hh:mm:ss') as TimeDiff
Update: 'TT' not 'tt'
Hi,
Use Interval().
For details see in help menu.
Regards
Try like:
Load
Interval(Time#(End_Time, 'hh:mm:ss TT')-Time#(Start_Time, 'hh:mm:ss TT'), 'hh:mm:ss') as TimeDiff
Update: 'TT' not 'tt'
Hi,
Function is Interval.
=Interval(time02 - Time01,'hh:mm')
thanx
Hi,
Try like this
=Interval(Timestamp#('3:19:21 AM', 'h:m:ss TT') | - Timestamp#('3:15:00 AM', 'h:m:ss TT'), 'h:m:ss TT') |
LOAD
*,
Interval(Timestamp#(EndTime, 'h:m:ss TT') | - Timestamp#(StartTime, 'h:m:ss TT'), 'h:m:ss TT') AS TimeDifference |
From DataSource;
Regards,
Jagan.
Hi
Create a field in your backend Script:
Interval(END_TIME - START_TIME,'hh:mm:ss') AS Time_Subtract
It will give you desired Result.
Also, see the Attachment.
Regards
Aviral Nag
Add one more line in your script...
Interval(Time#(END_TIME,'h:mm:ss TT')-Time#(START_TIME,'h:mm:ss TT'),'h:m:ss') as TimeDifference