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