LucidDbAppLib CURRENT DATE IN JULIAN

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Parameters 4 Example 5 Source Code

Syntax

APPLIB.CURRENT_DATE_IN_JULIAN()

Purpose

Returns the current date in Julian format (the number of days since the Julian start date of January 1, 1970).

NOTE: we do not calculate Julian days (JD) per the astronomical standard; they do not start noon Universal Time (UT) Monday, January 1, 4713 BC. So Julian days calculated using this function may not be in line with Julian days supplied by other systems.

Parameters

Example

Source Code

create or replace function applib.current_date_in_julian()
returns integer
deterministic
dynamic_function
contains sql
return (
  applib.day_from_julian_start(CURRENT_DATE)
);