# Discover page and read data

**URL:** <https://forum.opensearch.org/t/discover-page-and-read-data/20073>\
**Category:** Open Source Elasticsearch and Kibana\
**Created:** [June 30, 2024, 6:05am UTC](https://forum.opensearch.org/t/discover-page-and-read-data/20073 "2024-06-30T06:05:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![m\_pahlevanzadeh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/m_pahlevanzadeh/32/7468_2.png) [@m\_pahlevanzadeh](https://forum.opensearch.org/u/m_pahlevanzadeh)\
**Post date:** [June 30, 2024, 6:05am UTC](https://forum.opensearch.org/t/discover-page-and-read-data/20073/1 "2024-06-30T06:05:11Z")

</div>

Discover page read data correctly. with a date and time correctly.  
But I can’t read correctly with SQL.  
How can I read data such as Discover page?

---

<div class="post-metadata">

**Author:** ![gaobinlong](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/gaobinlong/32/5242_2.png) [@gaobinlong](https://forum.opensearch.org/u/gaobinlong)\
**Post date:** [July 1, 2024, 8:43am UTC](https://forum.opensearch.org/t/discover-page-and-read-data/20073/2 "2024-07-01T08:43:01Z")

</div>

Could you show the SQL you executed?

---

<div class="post-metadata">

**Author:** ![m\_pahlevanzadeh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/m_pahlevanzadeh/32/7468_2.png) [@m\_pahlevanzadeh](https://forum.opensearch.org/u/m_pahlevanzadeh)\
**Post date:** [July 1, 2024, 11:02am UTC](https://forum.opensearch.org/t/discover-page-and-read-data/20073/3 "2024-07-01T11:02:09Z")

</div>

select date,time from fortigate-logs-2024.06.29;

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/2X/3/33547ea01a5b12dcca2958411d3edd97ae2ea8c1.png) [@system](https://forum.opensearch.org/u/system)\
**Post date:** [August 30, 2024, 11:02am UTC](https://forum.opensearch.org/t/discover-page-and-read-data/20073/4 "2024-08-30T11:02:09Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.