Timestamp format

[bhavvibudagam]

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

[tresesco · Accepted solution]

Try like:

interval(Timestamp#(END_TIME,'YYYYMMDDhhmmss') - Timestamp#(START_TIME,'YYYYMMDDhhmmss'),'hh:mm')