Tag: N1QL Date Queries

Oracle Date Format: N1QL and Support for Date-Time Functions – Pt 1

Read the pdf version here. Date and Time functions and formats can vary for different databases. In the article we shall compare Couchbase N1QL Date-Time functions with Oracle ISO Date format. In Oracle, date format and timezones feature multiple data types,...

September 22, 2017

Querying Date Ranges within Embedded JSON Document Arrays. A Simple Example Using N1QL, Nodejs and Docker

Querying and indexing document arrays is one of the most powerful features of Couchbase.  Finding array entries within a specific date range is a common requirement.  Consider the following use case. User Story: “I want to index an embedded account...

July 18, 2017