[RESOLVED] Azure datetime UTC?

[sapator]

Hi.
I'm wondering if anyone is using Azure app insights to view logs?
We have 3 hours difference in UTC datetime but when I do this:

requests
| where timestamp between (datetime_utc_to_local(todatetime('2024-04-02T11:34:00'), 'Europe/Athens') .. datetime_utc_to_local(todatetime('2024-04-02T11:37:00'), 'Europe/Athens'))

I get -1 hour results.

[sapator]

OK So opposite selection works so I'm resolving myself.

traces
| where timestamp between (datetime_local_to_utc(todatetime('2024-04-12T10:30:00'), 'Europe/Athens') .. datetime_local_to_utc(todatetime('2024-04-12T10:37:00'), 'Europe/Athens'))