[Info-ingres] Database create time

[Martin Bowes]

Yes that works.

Ta.

Marty

From: Nick Makos [mailto:nick.makos at actian.com]
Sent: 03 October 2018 15:22
To: Martin Bowes; info-ingres at lists.planetingres.org
Subject: RE: [Info-ingres] Database create time

That constant is: 1451606400

From: Martin Bowes <martin.bowes at ndph.ox.ac.uk>
Sent: Wednesday, October 3, 2018 10:14 AM
To: Nick Makos <nick.makos at actian.com>; info-ingres at lists.planetingres.org
Subject: RE: [Info-ingres] Database create time

If I create a database right now, the db_id is 86969425

Date +%s is 1538576004

That's a hell of a difference.

Marty

From: Nick Makos [mailto:nick.makos at actian.com]
Sent: 03 October 2018 15:04
To: Martin Bowes; info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: RE: [Info-ingres] Database create time

In 2038, this i4 would overflow, so it's still the same thing - 46 years (or some constant that was chosen)

Regards,
--
Nick Makos
Director
Actian | Support
O +1.631.787.8213
actian.com

From: info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org> <info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org>> On Behalf Of Martin Bowes
Sent: Wednesday, October 3, 2018 9:41 AM
To: info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: [Info-ingres] Database create time

Hi All,

It used to be that the iidatabase catalog field db_id was the number of seconds since epoch for the database create.

But no longer the case in Ingres11.

Can anyone tell me what the db_id is relative to?

Martin Bowes


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20181003/dac993d7/attachment.html>