STR_TO_UTC conversion loosing precision for microseconds

SQL++
1

Problem
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?

Query

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

Ouput

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

2

N1QL supports time.RFC3339Milli only.

3

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

4

Not at present the time can be up to milliseconds.