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.
↪ replying to =?ISO-8859-1?Q?Herv=E9?=
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)
↪ replying to dcruncher4@aim.spam.com
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.