mirror of https://gitee.com/bigwinds/arangodb
29 lines
2.4 KiB
Plaintext
29 lines
2.4 KiB
Plaintext
arangosh> db._create(<span class="hljs-string">"exampleTime"</span>);
|
|
[ArangoCollection <span class="hljs-number">88789</span>, <span class="hljs-string">"exampleTime"</span> (type <span class="hljs-built_in">document</span>, status loaded)]
|
|
arangosh> <span class="hljs-keyword">var</span> timestamps = [<span class="hljs-string">"2014-05-07T14:19:09.522"</span>,<span class="hljs-string">"2014-05-07T21:19:09.522"</span>,<span class="hljs-string">"2014-05-08T04:19:09.522"</span>,<span class="hljs-string">"2014-05-08T11:19:09.522"</span>,<span class="hljs-string">"2014-05-08T18:19:09.522"</span>];
|
|
arangosh> <span class="hljs-keyword">for</span> (i = <span class="hljs-number">0</span>; i < <span class="hljs-number">5</span>; i++) db.exampleTime.save({<span class="hljs-attr">value</span>:i, <span class="hljs-attr">ts</span>: timestamps[i]})
|
|
arangosh> db._query(<span class="hljs-string">"FOR d IN exampleTime FILTER d.ts > '2014-05-07T14:19:09.522' and d.ts < '2014-05-08T18:19:09.522' RETURN d"</span>).toArray()
|
|
[
|
|
{
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"88796"</span>,
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"exampleTime/88796"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF6glS--A"</span>,
|
|
<span class="hljs-string">"value"</span> : <span class="hljs-number">1</span>,
|
|
<span class="hljs-string">"ts"</span> : <span class="hljs-string">"2014-05-07T21:19:09.522"</span>
|
|
},
|
|
{
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"88798"</span>,
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"exampleTime/88798"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF6glW---"</span>,
|
|
<span class="hljs-string">"value"</span> : <span class="hljs-number">2</span>,
|
|
<span class="hljs-string">"ts"</span> : <span class="hljs-string">"2014-05-08T04:19:09.522"</span>
|
|
},
|
|
{
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"88800"</span>,
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"exampleTime/88800"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF6glW--A"</span>,
|
|
<span class="hljs-string">"value"</span> : <span class="hljs-number">3</span>,
|
|
<span class="hljs-string">"ts"</span> : <span class="hljs-string">"2014-05-08T11:19:09.522"</span>
|
|
}
|
|
]
|