Page 1 of 1

check database date created

Posted: Mon Jan 05, 2009 3:00 pm
by pinoydaddy
Hello to all.

Is there a way to check the database date when it was created? If there is how?

Any help will be appreciate very much.

Vick

Re: check database date created

Posted: Mon Jan 05, 2009 3:16 pm
by andyhoneycutt
It's not uber accurate, but this sql statement might do it for ya:

Code: Select all

SELECT MIN(CREATE_TIME) FROM TABLES WHERE TABLE_SCHEMA='<databasename>'

Re: check database date created

Posted: Mon Jan 05, 2009 3:18 pm
by andyhoneycutt
alternately you could issue a system command to get the date/time of the database directory creation time, at least you could do that for mysql, not sure about any other dbms.

-Andy

Re: check database date created

Posted: Mon Jan 05, 2009 5:32 pm
by pinoydaddy
Thanks for your reply. I will try it right away and get back with the result..

Thank you so much once again.

Vick