Seconds since 2016-01-01, I believe.<br><br>On Wednesday, October 3, 2018, Nick Makos <<a href="mailto:nick.makos@actian.com">nick.makos@actian.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal" style="text-autospace:none">That constant is: <span style="font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:black">
1451606400</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank">martin.bowes@ndph.ox.ac.uk</a>> <br>
<b>Sent:</b> Wednesday, October 3, 2018 10:14 AM<br>
<b>To:</b> Nick Makos <<a href="mailto:nick.makos@actian.com" target="_blank">nick.makos@actian.com</a>>; <a href="mailto:info-ingres@lists.planetingres.org" target="_blank">info-ingres@lists.<wbr>planetingres.org</a><br>
<b>Subject:</b> RE: [Info-ingres] Database create time<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1f497d">If I create a database right now, the db_id is 86969425<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1f497d">Date +%s is 1538576004<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1f497d">That’s a hell of a difference.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1f497d">Marty<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif"> Nick Makos [<a href="mailto:nick.makos@actian.com" target="_blank">mailto:nick.makos@actian.com</a>]
<br>
<b>Sent:</b> 03 October 2018 15:04<br>
<b>To:</b> Martin Bowes; <a href="mailto:info-ingres@lists.planetingres.org" target="_blank">info-ingres@lists.<wbr>planetingres.org</a><br>
<b>Subject:</b> RE: [Info-ingres] Database create time<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal">In 2038, this i4 would overflow, so it’s still the same thing – 46 years (or some constant that was chosen)<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards,<br>
<span style="font-size:12.0pt;color:#767171">--<u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Nick Makos<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Director<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Actian | Support<u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">O</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif"> +1.631.787.8213<u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3062d4"><a href="http://actian.com" target="_blank">actian.com</a></span></b><span style="font-size:9.0pt;color:#3062d4"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:info-ingres-bounces@lists.planetingres.org" target="_blank">
info-ingres-bounces@lists.<wbr>planetingres.org</a> <<a href="mailto:info-ingres-bounces@lists.planetingres.org" target="_blank">info-ingres-bounces@lists.<wbr>planetingres.org</a>>
<b>On Behalf Of </b>Martin Bowes<br>
<b>Sent:</b> Wednesday, October 3, 2018 9:41 AM<br>
<b>To:</b> <a href="mailto:info-ingres@lists.planetingres.org" target="_blank">info-ingres@lists.<wbr>planetingres.org</a><br>
<b>Subject:</b> [Info-ingres] Database create time<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-GB">Hi All,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">It used to be that the iidatabase catalog field db_id was the number of seconds since epoch for the database create.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">But no longer the case in Ingres11.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">Can anyone tell me what the db_id is relative to?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">Martin Bowes <u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p>
</div>
</div>
</blockquote><br><br>-- <br><div dir="ltr"><div>Jonah H. Harris<br></div><div><br></div></div><br>