Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on converting below START TIME and END TIME to Time stamp like 2017-01-23 13:38:23(YYYY-MM-DD hh:mm:ss) from these need to calculate the duration like hh:mm
I have used the below expression but not working getting -.
Timestamp#(Timestamp(START_TIME,'YYYYMMDDhhmmss'),'YYYY-MM-DD hh:mm:ss')
Please help me on this
Thanks in advance
Try like:
interval(Timestamp#(END_TIME,'YYYYMMDDhhmmss') - Timestamp#(START_TIME,'YYYYMMDDhhmmss'),'hh:mm')
Try like:
interval(Timestamp#(END_TIME,'YYYYMMDDhhmmss') - Timestamp#(START_TIME,'YYYYMMDDhhmmss'),'hh:mm')