How can I get the current timestamp? Similar to Ruby’s
I would like to make a query like “Number unique users created 3 days ago”.
I was expecting something like this to work:
SELECT uniqueCount(user_id) FROM Transaction WHERE user_id is NOT NULL AND dateOf(user_created_date) = (current_timestamp() - 3 days)
It works if I use a plain String like
'December 21, 2015', but I would like this query to be dynamic instead of having to type a new date every time.
New Relic edit
- I want this, too
- I have more info to share (reply below)
- I have a solution for this
We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.