ilius

create or replace function epoch_to_jd(float) RETURNS int as $$
BEGIN
    return ($1 / (24*3600) + 2440588)::int;
END;
$$ LANGUAGE plpgsql;


create or replace function timestamp_to_jd(timestamp with time zone) RETURNS int as $$
BEGIN
    return epoch_to_jd(extract (epoch from $1));