Skip to end of banner
Go to start of banner

Note on dates with time

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Most Jira date fields also contain the time component. Jira doesn’t currently support convenient use of = and IN operators with timestamps. You should use the comparison operators instead: <, <=, >, >=

The following JQL aliases contain timestamps:

  • attachedOnDate

  • updatedOnDates

  • commentedOnDate

  • commentUpdatedDate 

For example, this query fails to find issues commented on a particular day:
commentedOnDate="2020/06/01"
Jira returns an empty result even if there are issues that were commented on 1 June.

The workaround is to search for the range of dates:
commentedOnDate>="2020/06/01" AND commentedOnDate<"2020/06/02"
Jira returns issues that were commented between midnight 1 June and midnight 2 June.

  • No labels