# Date Fields from PostgreSQL view get muddled in Index Pattern Search

**URL:** https://community.siren.io/t/date-fields-from-postgresql-view-get-muddled-in-index-pattern-search/138
**Category:** Siren Platform/Investigate Tech Support Community
**Created:** [October 16, 2019, 3:54pm UTC](https://community.siren.io/t/date-fields-from-postgresql-view-get-muddled-in-index-pattern-search/138 "2019-10-16T15:54:22Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![sireneer](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/sireneer/32/87_2.png) [@sireneer](https://community.siren.io/u/sireneer)
#### Post date: [October 16, 2019, 3:54pm UTC](https://community.siren.io/t/date-fields-from-postgresql-view-get-muddled-in-index-pattern-search/138/1 "2019-10-16T15:54:22Z")

</div>

I am using a view in PostgreSQL and for the date information I format the timestamp to a ISO date `to_char(time_informtion, 'YYYY-MM-DD HH24:MI:SS'::text)`.  
This works great while building the Data Reflection Job.  
However, if I create an Index Pattern Search based on the Data reflection, all the dates I have (starting Sep. 13, 2019) are displayed and interpreted as starting in January 2019.  
Any help is greatly appreciated.

---

<div class="post-metadata">

### Author: ![varun.sharma](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/varun.sharma/32/46_2.png) [@varun.sharma](https://community.siren.io/u/varun.sharma)
#### Post date: [October 25, 2019, 9:05am UTC](https://community.siren.io/t/date-fields-from-postgresql-view-get-muddled-in-index-pattern-search/138/2 "2019-10-25T09:05:09Z")

</div>

Could you please:

- Provide mapping for the index.
- Show one of the raw documents in question (Can be fetched via Dev Tools: `GET ${index-name}/doc/${document-id}`) and a screenshot of how it is being shown in the Ui.