date and time format in JQL query

Question

How I can change the format of date and time in JQL query?

I see dates and time for example in format:
February 17, 2023 9:00 AM
or 
En 1 semana

What??? in one week? which is this format ???
I need see dates and time in profesional format like dd/mm/yyyy hh:mi, view time in 24hs not in AM or PM

like this:
17/02/2023 21:00

Trudy P Claspill · Answer

I found these issues related to the relative display of date/time information in the Issue View screen.

https://jira.atlassian.com/browse/JRACLOUD-34511

https://jira.atlassian.com/browse/JRACLOUD-41506

https://jira.atlassian.com/browse/JRACLOUD-45928

Some of these have addition issues linked to them. I have not looked through all the linked issues to see if there is any reference to the display specifically within the Search results.

The relative display occurs when the date/time is within 1 week (before or after) the current date/time.

If you hover over the relative date/time display it will show you the absolute date/time.

In the issues I looked through so far I did not see any that have been resolved that would let you disable the relative date/time display.

Esther Strom · Answer

Yes, unfortunately Jira is known for date display issues. The edit mode fields will show number-only formats (18/2/23) because they use a date picker widget; when not editing the field they will show the longer format (18 Feb 2023).

As to why your search column is showing relative dates, I'm sorry - I don't have an answer. We only have one project that uses date/time fields instead of date-only, and it does show relative dates if I include one of those fields in a search column. I've looked through all of the admin settings and can't find anything that would turn it off and force all date/times to display as actual instead of relative date/times in filter columns.

Hopefully someone else has an answer that I've missed.

Roberto Miranda_e8tkbe · Answer

I don't know about date fields are native Jira dates or custom dates. I suppouse they are custom.
When I create a ticket, edit or view never see the dates fields in the same format.
You can see it in the attached screenshots.
month, day year time am/pm
relative date
day short month year time 24
day/number month/year time 24
day/short month/year time 24
it's a joke?
I tried choose format dates field in my profile, but it's blocked by admin.
thanks for your help