STR_TO_UTC conversion loosing precision for microseconds

While converting date field using the date function, STR_TO_UTC the Query engine is reducing the precision to milliseconds. How can I convert the date to UTC without losing the precision?


SELECT STR_TO_UTC(‘2020-12-06T08:50:55.8535865-05:00’) as utcDate;


“utcDate”: “2020-12-06T13:50:55.853Z”

N1QL supports time.RFC3339Milli only.

Are there any alternative functions available in N1ql which can be used to produce the expected output?

Not at present the time can be up to milliseconds.