How to put a date and time condition in a ADQL sta... - Splunk Community

Splunk AppDynamics

select * from transactions where order-date is between 01/01/2018 12:00:00 to 01/02/2019 12:00:02

Please make a note that the supported timestamp format is:

ISO 8601 format: yyyy-MM-dd'T'HH:mm:ss.SSSZZ
UNIX epoch date format: A 13-digit number representing the number of seconds/milliseconds since UNIX epoch time (Jan 1 1970). For example, (GMT): Mon, 17 Apr 2017 23:46:22 GMT would be 1492472782000.

About Orderdate, it appears to me that Orderdate is collected as a "String" and as you know, date manipulation does not work on string values.

Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...