Skip to content
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.

Sign up for GitHub

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

Jump to bottom

sql: Add useful Date/Timestamp functions. #2329

Closed
vivekmenezes opened this issue Sep 2, 2015 · 1 comment · Fixed by #2420
Closed

sql: Add useful Date/Timestamp functions. #2329

vivekmenezes opened this issue Sep 2, 2015 · 1 comment · Fixed by #2420
Assignees
@vivekmenezes
Milestone
Beta

Comments

@vivekmenezes
Copy link
Contributor

http://www.postgresql.org/docs/8.0/static/functions-datetime.html
lists all the functions. I think we should at least implement

age(timestamp, timestamp)
age(timestamp) -> interval
current_date
current_timestamp/localtimestamp/now
@petermattis
Copy link
Collaborator

We should also implement extract which looks like the workhorse for pulling components (year, month, day, hour, etc) out of a date/timestamp.

@petermattis petermattis added the SQL label Sep 2, 2015
@petermattis petermattis added this to the Beta milestone Sep 2, 2015
@vivekmenezes vivekmenezes self-assigned this Sep 2, 2015
@jess-edwards jess-edwards mentioned this issue Sep 3, 2015
Closed
78 tasks
@vivekmenezes vivekmenezes mentioned this issue Sep 9, 2015
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@vivekmenezes vivekmenezes

Labels
None yet
Projects
None yet
Milestone
Beta
Development

Successfully merging a pull request may close this issue.

Add important timestamp/date builtins. cockroachdb/cockroach
2 participants
@petermattis @vivekmenezes