I’m trying to find the time difference between current timestamp and the time a point is entered in influxdb
For example, below query gives me an entry from activealerts measurement.
select env, level, alert_name from activealerts order by time desc limit 1
time env level alert_name
1596542152514023232 uat CRITICAL alerts_cron_jobs
Here I would like to know, how much time have elapsed since this entry was made.
I tried as below
select now() - time, env, level, alert_name from activealerts order by time desc limit 1
ERR: undefined function now()
This seems very simple thing to do, but I dont know how to do it.