Skip to content

Support for reference times #5

@danp

Description

@danp

Thanks for this plugin!

As the example says:

dateutil_parse_fuzzy("This is due 10 september") returns 2020-09-10T00:00:00 (but will start returning the 2021 version of that if the year is 2021).

Maybe dateutil doesn't actually support this but it would be really nice to be able to give a reference time to dateutil_parse_fuzzy and probably other functions. For example, suppose I had a table like:

create table times (t datetime);
insert into times values (datetime('now')), (datetime('now', '-1 year')), (datetime('now', '-3 years'));

It would be nice to be able to do something like:

select t, dateutil_parse_fuzzy("This is due 10 september", t) from times

And have dateutil_parse_fuzzy work with t as its reference point.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions