I have a field containing seconds which I wish to convert to HH:mm:ss format in my visualization; I'm performing this using a scripted field of type date. This works fine, however if I specify a value of xx my conversion comes back with 1:00:xx. I assume the additional hour is due to my location which is currently under BST (UTC+1). So my question is how do I get the script to always return the value as UTC+0.
My script currently contains:
doc['doc.stats.OPERATOR_ASSISTS_AVERAGE_ANSWER_TIME'].value * 1000
Many thanks in advance