SQL Functions

The functions documented here may be useful when writing SQL.

The database contains a large number of functions but only those documented below are expected to be used directly by the database users.

• build_arrivals_seq() – Rebuild the ARRIVALS.Seq column
• build_sightings() – Rebuild the SIGHTINGS table
• build_swelling_states() – Rebuild the SWELLING_STATES table
• julian() – Convert a date to an integer which counts up by day
• julian_to() – Convert an integer which counts days to a date

Control Tables

The tables documented here exist to control and guide function behavior. They are located in the codes schema.

• SIGHTING_CONTROLS

Page last generated: 2026-08-13 23:02:22 UTC