Get week of day

#1

Is it possible to take the day of the week from the field time? I would like InfluxDB to only return the values from Monday to Friday.

For example: select mean(value) from data_x where week(time) not in (‘saturday’,‘sunday’)