# Influx question about WHERE time \>

**URL:** <https://discourse.nodered.org/t/influx-question-about-where-time/62919>\
**Category:** General\
**Created:** [21 May 2022 19:24 UTC](https://discourse.nodered.org/t/influx-question-about-where-time/62919 "2022-05-21T19:24:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikozo](https://avatars.discourse-cdn.com/v4/letter/v/858c86/32.png) [@vikozo](https://discourse.nodered.org/u/vikozo)\
**Post date:** [21 May 2022 19:24 UTC](https://discourse.nodered.org/t/influx-question-about-where-time/62919/1 "2022-05-21T19:24:21Z")

</div>

Hello  
i have a query

```auto
SELECT MIN(temp_mix) as MaMeMi24hd_MIN
FROM spez_days 
WHERE time > now()-30d

```

which works like this.  
But would it be possible to have something like  
WHERE time = this Month  
or  
WHERE time \> now() - beginMonth

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [22 May 2022 03:38 UTC](https://discourse.nodered.org/t/influx-question-about-where-time/62919/2 "2022-05-22T03:38:00Z")

</div>

You can use something like `WHERE time > '2022-05-01T00:00:00.000000000Z'`

---

<div class="post-metadata">

**Author:** ![edje11](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/edje11/32/572_2.png) [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [22 May 2022 12:44 UTC](https://discourse.nodered.org/t/influx-question-about-where-time/62919/3 "2022-05-22T12:44:11Z")

</div>

You can calculate in a function the first day of the month and use that in your query.

```auto
var date = new Date(), y = date.getFullYear(), m = date.getMonth();
var firstDay = new Date(y, m, 1);
msg.payload= firstDay

return msg;

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [21 July 2022 12:45 UTC](https://discourse.nodered.org/t/influx-question-about-where-time/62919/4 "2022-07-21T12:45:02Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.