NOTE: This page is experimental. Bug reports to carter.barry@gmail.com. Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT event,MIN(time) AS time FROM abqastro WHERE time >= DATETIME('now','localtime') GROUP BY event UNION SELECT "NOW", DATETIME('now', 'localtime') UNION SELECT event,MAX(time) AS time FROM abqastro WHERE time <= DATETIME('now','localtime') GROUP BY event ORDER BY time

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

event time
Full Moon 2018-04-29 18:58:00
Last Quarter 2018-05-07 20:09:00
New Moon 2018-05-15 05:48:00
First Quarter 2018-05-21 21:49:00
MS 2018-05-22 02:06
ATS 2018-05-22 04:16
NTS 2018-05-22 04:54
CTS 2018-05-22 05:29
SR 2018-05-22 05:58
MR 2018-05-22 13:27
SS 2018-05-22 20:09
CTE 2018-05-22 20:37
NTE 2018-05-22 21:12
ATE 2018-05-22 21:50
NOW 2018-05-23 01:17:18
MS 2018-05-23 02:44
ATS 2018-05-23 04:15
NTS 2018-05-23 04:54
CTS 2018-05-23 05:29
SR 2018-05-23 05:57
MR 2018-05-23 14:30
SS 2018-05-23 20:09
CTE 2018-05-23 20:38
NTE 2018-05-23 21:13
ATE 2018-05-23 21:51
Full Moon 2018-05-29 08:20:00
Last Quarter 2018-06-06 12:32:00
New Moon 2018-06-13 13:43:00
First Quarter 2018-06-20 04:51:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query