`timestamp` condition in `--analytics-query` does not seem to work

[ecormaksin]

Describe the bug

When I execute a query like traces | where timestamp >= datetime(2023-06-06 00:00:00) at Azure Portal (Application Insights - Monitoring - Logs pane), I can get an expected result.

However, when I execute the same query using az monitor app-insights query --analytics-query command, I cannot get the same result. I have to specify a timestamp range using --start-time and --end-time option.

Related command

az monitor app-insights query

Errors

Errors do not occur. Just I cannot get an expected result as same as executing a Kusto query at Azure Portal.

Issue script & Debug output

Nothing.

Expected behavior

I can get an expected result as same as executing a Kusto query at Azure Portal.

Environment Summary

Here is my output.

> az --version
azure-cli                         2.49.0

core                              2.49.0
telemetry                          1.0.8

Extensions:
application-insights              0.1.19

Dependencies:
msal                              1.20.0
azure-mgmt-resource               22.0.0

Python location 'C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\python.exe'
Extensions directory '$Env:USERPROFILE\.azure\cliextensions'

Python (Windows) 3.10.10 (tags/v3.10.10:aad5f6a, Feb  7 2023, 17:05:00) [MSC v.1929 32 bit (Intel)]

Legal docs and information: aka.ms/AzureCliLegal


Your CLI is up-to-date.

Additional context

No response

[yonzhan]

Thank you for opening this issue, we will look into it.

[ecormaksin]

@yonzhan Is there any progress...?