Subject | Re: [firebird-support] Getting database creation date programatically |
---|---|
Author | Josef Kokeš |
Post date | 2012-06-15T07:31:24Z |
On 15.6.2012 9:19, Thomas Steinmaurer wrote:
But in the meantime I will query mon$database on my newer servers. Thanks.
Pepak
>> I need to find the date of last database restore. GSTAT -h can printUnfortunately, I need this information for Firebird 1.0, too :-(
>> this information as "Creation date". Does anyone know how can I get this
>> information programatically?
>
> If monitoring tables are available, it might be easier to query
> MON$DATABASE with e.g.:
>
> select mon$creation_date from mon$database
But in the meantime I will query mon$database on my newer servers. Thanks.
Pepak