There several books that provide methods to compute the phase of the moon and moonrise/set times. Two are:
"Astronomical algorithms" by Jan Meeus.
"Practical astronomy with your calculator or spreadsheet", by Peter Duffett Smith
You have some coding to do to implement the maths, it is not a database problem you can solve with lookup tables or sql queries.
|