Q: How do I query for a specific date on created_at/modified_at?

[ddanieltan]

select * from files
where modified_at = "<current date>"

doesn't work. I've tried variations with single apostrophes or no apostrophes.

Are created_at and modified_at datetime fields in the SQL engine used? Could we have examples in the documentation on the correct format to query for a specific date?

Side note: Suggest you create a Discussions tab for your github project? I would have put my question there instead of filing an issue.

[kulak-at]

Good idea with the discussion! I will create it soon!

To get all files modified today you can run the following query:

SELECT * FROM files
WHERE date(modified_at) = date('now')

You can read more about date time operations in SQLite here.

Note that currently SQLSeal does not use the latest version of SQLite so functions like timediff are not available unfortunately but it should get updated soon!