I am trying to define a query where I have to use the earliest time as 2 days ago at 22:20:45 and latest time 1 day ago at 22:20:45
I tried different formats below
But - I am not sure if these are correct and also how can I check if this translates to the date and time I am trying to set.
I've used similar formats before - only with a single add-on (-1@d+8h, for example) - but I think it should work.
Fix the earliest to -2d@d+22h+20m+45s
To verify you're getting the right start and end times, add the addinfo command to your query and display the info_min_time and info_max_time fields.
View solution in original post