Subject | Re: [firebird-support] Getting database creation date programatically |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-06-15T07:37:46Z |
> On 15.6.2012 9:19, Thomas Steinmaurer wrote:In general, you can use the Services API to fetch the header page and
>>> I need to find the date of last database restore. GSTAT -h can print
>>> 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
>
> Unfortunately, I need this information for Firebird 1.0, too :-(
then parse the content to get the creation date.
Depending on your used database access layer product/components,
especially in the Delphi world, they usually offer components which wrap
the Services API calls/layer into an ease to use object model.
So, what database access layer do you use?
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/