Couchbase N1QL DATE_FORMAT_STR offset handling for mixed regional ISO 8601 timestamps
Documents in the bucket store event times as ISO 8601 strings that include regional offsets, such as 2026-10-16T10:00:00+05:30 , and reporting requirements call for output in a different regional time zone. Because Couchbase lacks a native DateTime type, the unresolved choice is whether to convert these strings at query time with DATE_FORMAT_STR or normalize
couchbase