A very basic question.
I’m using a SELECT query to get some traffic utilization for a device ‘abcd’ for Nov, 2017:
influx -execute “SELECT time, value FROM util_db WHERE hostname=‘abcd’ AND time >= ‘2017-11-01T00:00:00Z’ AND time <= ‘2017-11-30T00:00:00Z’ GROUP BY hostname” -database=mydb -precision=‘RFC3339’
The output is in the form below.
I need to do some further processing on the output for which I need to know the ‘DAY’ (e.g Mon/Tue/Wed…) from the time-stamp. Is there a way to update the query to include the day of the week in the time-stamp?