cheminfo / cheminfo/smart-sqlite3-filter
Support date query
Open
- Dominant language
- TypeScript
- Stars
- 1
- Forks
- 1
- PR merge metrics
- No merged PRs in 30d
Description
Sqlite3 does not have a DATE or DATETIME column type but would actually store this information in its schema if not in STRICT mode.
This means that we can also add smart filter on DATE, DATETIME
However the format in which the DATE / DATETIME are stored is not enforced so will depend from one application to another.
There could be a default behaviour but likely we should provide callback to deal with dates stored as Epoch in milliseconds or [ISO 8601](https://fr.wikipedia.org/wiki/ISO_8601)
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.