This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.

filter alarm table
#16
There's no date format in the database, UNIX timestamp (integer) is used to store date/time. Either the query is incorrect or you don't have alerts matching the requested time-frame.
Run this script once and post what got get in Logs tab:
Code:
data = db:getall('SELECT COUNT(1) total, MIN(alerttime) tmin, MAX(alerttime) tmax FROM alerts')
log(data)
Reply


Messages In This Thread
filter alarm table - by Frank68 - 12.02.2021, 12:07
RE: filter alarm table - by admin - 12.02.2021, 12:14
RE: filter alarm table - by Frank68 - 12.02.2021, 12:41
RE: filter alarm table - by admin - 12.02.2021, 13:04
RE: filter alarm table - by Frank68 - 12.02.2021, 13:12
RE: filter alarm table - by admin - 12.02.2021, 13:20
RE: filter alarm table - by Frank68 - 12.02.2021, 13:35
RE: filter alarm table - by admin - 12.02.2021, 13:45
RE: filter alarm table - by Frank68 - 12.02.2021, 13:49
RE: filter alarm table - by admin - 12.02.2021, 14:00
RE: filter alarm table - by Frank68 - 12.02.2021, 14:07
RE: filter alarm table - by admin - 12.02.2021, 14:18
RE: filter alarm table - by Frank68 - 12.02.2021, 14:22
RE: filter alarm table - by admin - 12.02.2021, 14:25
RE: filter alarm table - by Frank68 - 12.02.2021, 14:30
RE: filter alarm table - by admin - 12.02.2021, 14:40
RE: filter alarm table - by Frank68 - 12.02.2021, 14:56
RE: filter alarm table - by admin - 12.02.2021, 15:14
RE: filter alarm table - by Frank68 - 12.02.2021, 15:21
RE: filter alarm table - by admin - 12.02.2021, 15:27
RE: filter alarm table - by Frank68 - 12.02.2021, 15:35
RE: filter alarm table - by admin - 12.02.2021, 15:41
RE: filter alarm table - by Frank68 - 12.02.2021, 15:56
RE: filter alarm table - by admin - 12.02.2021, 16:59
RE: filter alarm table - by Frank68 - 15.02.2021, 07:03
RE: filter alarm table - by admin - 15.02.2021, 07:49
RE: filter alarm table - by Frank68 - 15.02.2021, 08:03

Forum Jump: