How to get the last updated date of a database?
This is a discussion on How to get the last updated date of a database? within the Database Support forums, part of the Web Development category; hi... How to get the last updated date of a Mysql Database? Regards, S.Ashokkumar....
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
05-07-2007, 07:18 AM
| |||
| |||
 How to get the last updated date of a database? hi... How to get the last updated date of a Mysql Database? Regards, S.Ashokkumar. Last edited by write2ashokkumar : 05-07-2007 at 07:26 AM.     |
| Sponsored Links |
|
05-09-2007, 06:30 AM
| |||
| |||
| Re: How to get the last updated date of a database? hi... To get the last updated date of a database, use the following query. SELECT TABLE_SCHEMA,UPDATE_TIME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '<Database Name>' ORDER BY UPDATE_TIME DESC LIMIT 1; Thanks & Regards, S.Ashokkumar |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert a date in milliseconds back to a date string | itbarota | HTML, CSS and Javascript Coding Techniques | 2 | 03-03-2008 09:03 PM |
| How can I show the documents last modified date in the format: month, date, year, tim | Pvinothkumar | HTML, CSS and Javascript Coding Techniques | 3 | 12-28-2007 05:58 AM |
| How can I compare a date in a string with todays date? | itbarota | HTML, CSS and Javascript Coding Techniques | 2 | 12-18-2007 11:02 PM |
| How to find the Starting date of week from a particular date | kingmaker | C# Programming | 1 | 08-16-2007 11:25 PM |
| How to convert a date to a globally accepted date format, in DOT NET 2005? | Archer | C# Programming | 1 | 07-25-2007 03:21 AM |
All times are GMT -7. The time now is 08:22 PM.
