Informix Record Time Stamp

Hello, I'm using IDS 7.31 and I'd like to know if it's possible to retrieve the timestamp of a record (creation or last update date) with an SQL request ? And if possible, how ? Thanks a lot.

In article <a3cca790-6bf0-43cc-842a-60d4a872a29d@l33g2000pri.googlegroups.com>, =?ISO-8859-1?Q?Herv=E9?= says... > >Hello, > >I'm using IDS 7.31 and I'd like to know if it's possible to retrieve >the timestamp of a record (creation or last update date) with an SQL >request ? > >And if possible, how ? > >Thanks a lot. > Yes only if you are using Enterprise replication by querying hidden column cdrtime. select dbinfo('utc_to_datetime',cdrtime)

On 20 Jan, 14:49, dcrunch...@aim.spam.com wrote: > In article <a3cca790-6bf0-43cc-842a-60d4a872a...@l33g2000pri.googlegroups.com>, > =?ISO-8859-1?Q?Herv=E9?= says... > > > > >Hello, > > >I'm using IDS 7.31 and I'd like to know if it's possible to retrieve > >the timestamp of a record (creation or last update date) with an SQL > >request ? > > >And if possible, how ? > > >Thanks a lot. > > Yes only if you are using Enterprise replication by querying > hidden column cdrtime. > select dbinfo('utc_to_datetime',cdrtime) Add a new column with defaulut current and an update trigger to set the column when the row is updated.