JQL filter for time without a date

[Patrick Windsor]

Hello I am on JIRA Cloud and I would like to know if there is a way to use JQL to filter based upon time and not date. So essentially I want to see all issues created between the hours of 8am and 8pm, again without any date rage.

[ssraghavan]

try this in your sql

created > startOfDay("+8h") and created < startOfDay("+16h") 

[Patrick Windsor]

I will try that, but does it not limit itself to the current date? I am looking for a few reasons, I want to back historically and look at all tickets that were opened during off hours versus business hours.