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

[Nic Brough -Adaptavist-]

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.

[Josh Simnitt]

If auditing enabled:

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

[kai liu]

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.

[Daniel Wester]

Can you expand on what you're trying to do?