# Create nested hour field in date field
**URL:** https://discuss.elastic.co/t/create-nested-hour-field-in-date-field/57667
**Category:** Elasticsearch
**Created:** [August 10, 2016, 8:04am UTC](https://discuss.elastic.co/t/create-nested-hour-field-in-date-field/57667 "2016-08-10T08:04:18Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@no\_jihun](https://discuss.elastic.co/u/no_jihun)
#### Post date: [August 10, 2016, 8:04am UTC](https://discuss.elastic.co/t/create-nested-hour-field-in-date-field/57667/1 "2016-08-10T08:04:18Z")
Hi.
Is it possible to create hour field inside of date field on indexing time?
```
"properties": {
"time": {
"format": "yyyy-MM-dd HH:mm:ss Z",
"type": "date"
}
}
```
With mapping above I expect something like below.
```
"properties": {
"time": {
"format": "yyyy-MM-dd HH:mm:ss Z",
"type": "date",
"fields": {
"hour": {
"format": "HH",
"type": "date or.. integer
}
}
}
}
```
so that it will have hour field
```
{
"time" : "2016-08-10 14:23:44 +0000",
"time.hour" : "14"
}
```
I am aware of a way that using scripted field.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [August 10, 2016, 9:31pm UTC](https://discuss.elastic.co/t/create-nested-hour-field-in-date-field/57667/2 "2016-08-10T21:31:57Z")
You'd need to pass it in during indexing I think.
---
### Author:  [@no\_jihun](https://discuss.elastic.co/u/no_jihun)
#### Post date: [August 11, 2016, 2:20am UTC](https://discuss.elastic.co/t/create-nested-hour-field-in-date-field/57667/3 "2016-08-11T02:20:01Z")
This need is a kind of to get date aggregation.
something like DAY\_OF\_WEEK agg, HOUR\_OF\_DAY agg.
Since es does not support this for now, I will pass pre formatted hour, day values.
Thanks @warkolm .
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 10:28pm UTC](https://discuss.elastic.co/t/create-nested-hour-field-in-date-field/57667/4 "2017-07-05T22:28:38Z")