Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table that contains this tow columns i want to calculate the duration time in a new column the both column are timestamp data type
Try this @abTech
Interval( Timestamp#(EndDate, 'MM-DD-YY hh:mm TT') - Timestamp#(StartDate, 'MM-DD-YY hh:mm TT'), 'hh:mm' )