Discover page and read data

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?

Could you show the SQL you executed?

select date,time from fortigate-logs-2024.06.29;