Re: creation date
From: "Davide Locatelli" <davide.locatelli@rulmeca.it>
>
>In Informix 7.31 is there a way to know the creation date of a table ?
>I think I have to look at the sysmaster database, but in what way ?
This comes from the local database:
select created from systables where tabname = "xxx";
From sysmaster:
select dbinfo('UTC_TO_DATETIME', ti_created)
from systabinfo, systabnames
where tabname = "xxx"
and ti_partnum = partnum;
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com