Commit

b656187

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 181a7bdd5

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.

Ralph Schindler @ralphschindlerOct 181/2925bc89

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.

Ralph Schindler @ralphschindlerOct 182/2

That said, if you needed more granular queries against the EDTF data itself, you could always use the RDBMS's native JSON functions. That gives you some flexibility without having to add a bunch of dedicated columns.

23:07 · Oct 18, 2026commit b656187