Tag: N1QL Date Queries

Oracle Date Format: N1QL and Support for Date-Time Functions

Oracle Date Format: N1QL and Support for Date-Time Functions

Date and Time functions and formats can vary for different databases. In this article, we shall compare Couchbase ISO-based Date-Time functions with Oracle Date format. Date formats vary between relational and NoSQL database due to the nature of NoSQL JSON...

Couchbase Product Marketing September 22, 2017
Querying Date Ranges within Embedded JSON Document Arrays.  A Simple Example Using N1QL, Nodejs and Docker

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...

Todd Greenstein July 18, 2017