Return timestamp in JQL

[VL]

When I return fields like created, updated via JQL, they are formatted like 01/Sep/20.   How do I get the timestamp as well, so HH:MM:SS  appended?

[Deepanshu Natani]

Hi @VL 

At present, this is not possible.

You can register your interest for this feature here: https://jira.atlassian.com/browse/JRASERVER-70425

[VL]

Hi @de thanks for your reply.   Is it possible to obtain via a SQL query on the database?  If so would you have a sample query or two to share to get the common fields for an issue?

[Deepanshu Natani]

Hi @VL ,

I am not sure about the query to fetch the data from the database. However, that should be possible since this data is available in the database.

You can probably ask another question for that.