Subject | Re: [firebird-support] Getting the Last Date a Database was Restored |
---|---|
Author | Norman Dunbar |
Post date | 2010-05-11T18:47:29Z |
Evening Marius,
gstat -header <database> | grep -i creation
That will give you the "Creation date": The date that this database was
created originally. It may show the date that the database was last
restored by gbak.
In FB 2.x there are the MON$ tables.
Select MON$CREATION_DATE from MON$DATABASE coule be the one you want.
HTH
Cheers,
Norman.
>> Can someone tell me if it is possible to query one of the systemOne method is to :
>> databases, to retrieve the last date a database was restored?
gstat -header <database> | grep -i creation
That will give you the "Creation date": The date that this database was
created originally. It may show the date that the database was last
restored by gbak.
In FB 2.x there are the MON$ tables.
Select MON$CREATION_DATE from MON$DATABASE coule be the one you want.
HTH
Cheers,
Norman.