Hello Norman,

Thank you for assisting.

That is the exact date/time combination I am looking for.

select MON$CREATION_DATE
from MON$DATABASE

Regards
Marius

On 11/05/2010 20:47, Norman Dunbar wrote:
>
> Evening Marius,
>
> >> Can someone tell me if it is possible to query one of the system
> >> databases, to retrieve the last date a database was restored?
>
> One method is to :
>
> 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.
>
>
> _,___



[Non-text portions of this message have been removed]