<story><title>Show HN: High-precision date/time in SQLite</title><url>https://antonz.org/sqlean-time/</url></story><parent_chain></parent_chain><comment><author>alberth</author><text>Does this handle the special case of timezone changes (and local time discontinuity) that Jon Skeet famously documented?&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;stackoverflow.com&amp;#x2F;questions&amp;#x2F;6841333&amp;#x2F;why-is-subtracting-these-two-epoch-milli-times-in-year-1927-giving-a-strange-r&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;stackoverflow.com&amp;#x2F;questions&amp;#x2F;6841333&amp;#x2F;why-is-subtracti...&lt;/a&gt;&lt;p&gt;And computerphile explains so well in their 10-min video:&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.youtube.com&amp;#x2F;watch?v=-5wpm-gesOY&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.youtube.com&amp;#x2F;watch?v=-5wpm-gesOY&lt;/a&gt;&lt;p&gt;---&lt;p&gt;I&amp;#x27;ve long ago learned to never build my own Date&amp;#x2F;Time nor Encryption libraries. There&amp;#x27;s endless edge cases that can bite you hard.&lt;p&gt;(Which is also why I&amp;#x27;m skeptical when I encounter new such libraries)</text></comment>
<story><title>Show HN: High-precision date/time in SQLite</title><url>https://antonz.org/sqlean-time/</url></story><parent_chain></parent_chain><comment><author>mynameisash</author><text>I find the three different time representations&amp;#x2F;sizes curious (eg, what possible use case would need nanosecond precision over a span of billions of years?). More confusing is that there&amp;#x27;s pretty extreme time granularity, but only ±290 years range with nanosecond precision for time durations?</text></comment>