New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support timestamp and time functions on SQL fliters #844
Comments
Perhaps abbreviations to SI standards will reduce i18n? |
I'd probably lean towards whatever is in the SQL-99 standard (or later equivalent); I picked those out of a SQL manpage, but this book seems to be freely available and cover the standard itself. |
It looks like the proper SQL way to write the first clause would be:
|
That makes complete sense and I feel a little foolish in hindsight. Thank you for helping remind me of context! 😄 |
|
This issue is stale because it has been open for 30 days with no |
@evankanderson or perhaps @Cali0707 - does Knative need/want this? Perhaps a PR?? |
@duglin I can definitely see where this would be useful for Knative, I can work on thinking this through more and opening a PR but I won't get it done in time for the call this week - hopefully next week! Would you be able to assign this to me? |
done and thanks |
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:
The text was updated successfully, but these errors were encountered: