nowfound

Life & fun · August 15, 2024

High-precision date/time in SQLite

A rich set of functions for working with date, time and durations.

High-precision date/time in SQLite launched on August 15, 2024 with 274 votes, #170 of 5,471 launches that month and more than 95% of that year's launches. The site was still online in September 2026, 2 years on.

Visit antonz.org ↗Alternativestop 3% of August 2024

In plain words

High-precision date/time in SQLite is a tool for developers working with SQLite databases who need to handle dates and times with greater accuracy than SQLite's built-in functions provide. It extends SQLite's native date/time capabilities to support higher precision temporal data. The tool is designed for applications requiring exact timestamp handling and sophisticated date/time operations within SQLite environments.

written from the facts on this page · September 2026

From the sources

While SQLite provides a certain number of date functions, I wanted something more. So I've created sqlean-time — a high-precision date/time extension with a structured API and a rich set of functions. Note . Adding extensions to SQLite is a breeze. Download a file, run one database command — and you are good to go. This extension works with two types of values: Time and Duration. Time is a pair (seconds, nanoseconds), where seconds is the 64-bit number of seconds since zero time (0001-01-01 00:00:00 UTC) and nanoseconds is the number of nanoseconds within the current second (0-999999999). For maximum flexibility, you can store time values in their internal representation (a 13-byte BLOB).…from antonz.org

Does a similar job

all alternatives →
  • SO
    SQLite Online – 11 years of solo development, 11K daily users2025 · sqliteonline.com · ▲465

    SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics

  • BS
    Better SQL group by date2013 · ankane.github.io · ▲60
  • SQLite Playground2021 · sqlime.org · ▲213

    Sqlime is an online SQLite playground for debugging and sharing SQL snippets.

  • Moment.js2015 · momentjs.com · ▲279

    Parse, validate, manipulate, and display dates in JavaScript

  • Time Calc2017 · 8mobile.org · ▲93

    Calculator to perform elementary operations on units of time

  • DBOSify – Drop-in Temporal replacement built on PostgresJun 2026 · github.com · ▲91

    Postgres-Backed Drop-in Temporal Replacement. Contribute to dbos-inc/dbosify-py development by creating an account on GitHub.

More life & fun this month

the category →

Source: Show HN post ↗

Launched alongside, August 2024

the whole month →
  • Wordware▲9,848

    Your tool for building AI agents with natural language

    AI · 2024 · wordware.ai

  • If YouTube had actual channels▲2,741

    If Youtube had actual channels.

    Life & fun · 2024 · ytch.xyz

  • Me.bot▲1,627

    The inspiring companion for your life

    AI · 2024 · me.bot

  • Upmetrics AI▲1,197

    Business plan & financial forecast using AI

    Work · 2024 · upmetrics.co

  • Jupitrr AI▲1,195

    Jupitrr AI turns raw talking videos into scroll-stopping content for coaches and consultants. Research, script, record, edit, and publish in one app.

    AI · 2024 · jupitrr.com

  • InstantDB – A Modern Firebase▲1,145

    Hey there HN! We’re Joe and Stopa, and today we’re open sourcing InstantDB, a client-side database that makes it easy to build real-time and collaborative apps like Notion and Figma. Building modern apps these days involves a lot of schleps. For a basic CRUD app you need to spin up servers, wire up endpoints, integrate auth, add permissions, and then marshal data from the backend to the frontend and back again. If you want to deliver a buttery smooth user experience, you’ll need to add optimistic updates and rollbacks. We do these steps over and over for every feature we build, which can…

    Dev tools · 2024 · github.com