Could I search the 'Project Created Time' in JIRA database?

Question

Josh Simnitt · Answer

If auditing enabled:

/*When was a project created?*/
SELECT *
FROM audit_log
WHERE SUMMARY = 'Project created';

Nic Brough -Adaptavist- · Answer

No, there is no field for that, it is not stored.

The best you can do is approximate it by looking at the project's ID in the database and the first created issue in it and the projects either side of it.

kai liu · Answer

I'm trying to write a sql to search out the Project Create Date. But I can't find the field in the tables of JIRA.

So I want to know is there a field in the tables that storing such data.

Thank you.