LucidDbAppLib DAY FROM JULIAN START

From Eigenpedia

Jump to: navigation, search

Contents

Syntax 

APPLIB.DAY_FROM_JULIAN_START ( date )

Purpose

Returns an integer value representing the number of days since 1 JAN -4712 (4713 BC) (Julian start date).

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. Also, BC dates are not currently supported.

Parameters

  • date: date for which to return the number of days since the julian start date [date]

Output

  • [INTEGER] the Julian day, number of days from Julian start date for the date passed in

Example 

Values( APPLIB.DAY_FROM_JULIAN_START(DATE'1900-12-13') )
Example return
DAY_FROM_JULIAN_START(DATE'1900-12-13')
2415367

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/datetime/ConvertJulianDayUdf.java

Retrieved from "http://pub.eigenbase.org/wiki/LucidDbAppLib_DAY_FROM_JULIAN_START"
Personal tools