cheminfo / cheminfo/smart-sqlite3-filter

Support date query

Open
#10 0 comments 0 reactions 1 assignee Claimed by @lpatiny View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.