cloudevents / cloudevents/spec
Support timestamp and time functions on SQL fliters
Open
@Cali0707 is already working on this.
Since Mar 21, 2024.
CESQL Spec
- Dominant language
- Python
- Stars
- 5.9k
- Forks
- 613
- Avg merge
- 2d 17h
- Merged PRs (30d)
- 3
Description
Had a conversation today with a user who wanted to be able to apply a filter like the following:
SELECT * WHERE time < NOW() - "5 minutes"
It would be handy to have a timestamp type and a handful of time-related functions. Off the top of my head:
- NOW()
- ADD / SUBTRACT
- MINUTE / HOUR / DAY / DAY_OF_WEEK / MONTH / YEAR
- LESS-THAN / GREATER-THAN
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.