elasticsearchHow can I store and query zoned datetime values in Elasticsearch?
Elasticsearch provides the ability to store and query zoned datetime values using the date
datatype. It is important to note that the date
datatype only supports ISO8601 formatted dates.
For example, to store a zoned datetime value of 2020-05-01T12:00:00+02:00
, you would use the following code:
PUT my_index/_doc/1
{
"my_date": "2020-05-01T12:00:00+02:00"
}
To query for the zoned datetime value, you would use the range
query:
GET my_index/_search
{
"query": {
"range": {
"my_date": {
"gte": "2020-05-01T12:00:00+02:00"
}
}
}
}
The output of the query should look like this:
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": 1.0,
"hits": [
{
"_index": "my_index",
"_type": "_doc",
"_id": "1",
"_score": 1.0,
"_source": {
"my_date": "2020-05-01T12:00:00+02:00"
}
}
]
}
}
In summary, storing and querying zoned datetime values in Elasticsearch can be done using the date
datatype and the range
query.
Helpful links
More of Elasticsearch
- How can I set up and use Elasticsearch on the Yandex Cloud platform?
- How do I configure elasticsearch to use an XMS memory allocator?
- How can I use elasticsearch zone awareness to improve my software development?
- How do I configure Elasticsearch shards?
- How can I use Elasticsearch and ZFS together?
- How can I use Elasticsearch and Zookeeper together to manage distributed applications?
- How do I use Elasticsearch with Python?
- How can I use Elasticsearch and Zabbix together for software development?
- How do I use Elasticsearch with ZGC?
See more codes...