Find JIRA tickets created between 9.00 am and 10.00 am

Question

Assuming I have hours per day set at 8 and start time set at 9.00 am how can I narrow down tickets using a JQL filter for tickets created between 9.00 am and 10.00 am? I was thinking something like:

AND updated > startOfDay() AND updated < startOfDay("+1h")  

Answer 1

Please see my answer here: Filter issues updated by particular user in period of time using JQL

It seems like you are asking the same question. Hopefully this helps you out.

Answer 2

A scripted field using Script Runner plugin will show the hour:

import java.util.Calendar
Calendar cal = Calendar.getInstance()
cal.setTime(issue.created)
cal.get(Calendar.HOUR_OF_DAY).toString()