Results 1 to 2 of 2

Thread: [RESOLVED] Azure datetime UTC?

  1. #1

    Thread Starter
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    6,621

    Resolved [RESOLVED] Azure datetime UTC?

    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:
    Code:
    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.
    ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
    πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·

  2. #2

    Thread Starter
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    6,621

    Re: Azure datetime UTC?

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

    Code:
    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'))
    ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
    πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width