[Info-ingres] Database create time

[Jonah H. Harris]

Seconds since 2016-01-01, I believe.

On Wednesday, October 3, 2018, Nick Makos <nick.makos at actian.com> wrote:

> 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 <nick.makos at actian.com>]
> *Sent:* 03 October 2018 15:04
> *To:* Martin Bowes; 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 <http://actian.com>*
>
>
>
> *From:* info-ingres-bounces at lists.planetingres.org <
> 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
> *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
>
>
>
>
>


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