Built-in hourly trigger

How can i get a built-in Boolean SQLTag that goes high for like five seconds every hour?

Make a DB Tag and use this expression:

if(dateExtract(now(),"min")=0 && dateExtract(now(),"sec")<5,1,0)

Hope this helps!


1 Like

Slightly OT, but a variation on a theme.

5-sec pulse every quarter hour:

(switch(dateExtract(now(),"min"),0,15,30,45,1,1,1,1,0)) && (dateExtract(now(),"sec")<5)
1 Like

Great suggestions!

Maybe i was thinking way out of the box…