Discover page and read data

Open Source Elasticsearch and Kibana
1

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?

2

Could you show the SQL you executed?

3

select date,time from fortigate-logs-2024.06.29;