John Beales: “Maybe separate billable month/day/year columns, where null r…”

Ralph Schindler @ralphschindlerOct 183d9ae0e

How do you store a date when you don't actually know the date? "Born around 1926" or "died sometime in 1937" doesn't fit neatly into a database date column. I built laravel-edtf to handle fuzzy, approximate, and uncertain dates in Laravel, with Eloquent casts, queryable…

GitHubGitHub - smwks/laravel-edtfContribute to smwks/laravel-edtf development by creating an account on GitHub.

John Beales @jbealesOct 18

Maybe separate billable month/day/year columns, where null represents “unknown”? You could even expand that to add a -variance column to each so you know writhing that column’s number of years/months/days, or a Boolean “approximate” flag for each column.

22:46 · Oct 18, 2026commit 1a7bdd5

Ralph Schindler @ralphschindlerOct 18

That could work for simpler cases, but it gets complicated pretty quickly. EDTF is an existing standard that handles uncertain dates, approximate dates, ranges, open intervals, and unspecified components. The package uses a JSON column to store the EDTF representation and…

loc.govExtended Date Time Format (EDTF) Specification (Library of Congress)Extended Date Time Format. A supporting xml schema allowing for implementation of element set and is maintained in Network Development and MARC Standards Office, Library of Congress.

Show thread

Commit