(SQL*Plus User's Guide and Reference; search in this book)
The sequential day count reckoned consecutively beginning January 1, 4713 B.C.
The basis of time for astrodynamics. The number of days since 12:00 on 1 January 4713 B.C. The Julian Day for 1 January 2000 at noon is 2,451,545.0.
the interval of time in days and fraction of a day since 4713 B.C. January 1, Greenwich noon, Julian proleptic calendar. In precise work the timescale, e.g., dynamical time or universal time, should be specified.
A three-digit number indicating the day of the year. January 1 is 001 and December 31 is 365 or 366.
A number between 1 and 365 referring to a specific date of the year for either the packing date or expiration date of the beer.
The number of days since noon, Greenwich time, on January 1, 4713 BC. Noon on that day was Julian Day 0.00. At 6 pm on that date, it was Julian Day 0.25. At 6 pm on January 2, 4713 BC, it was Julian Day 1.25. Thus, the Julian Date specifies both the date and the time of day. As this entry was written, at 10:30 am PDT on October 7, 2003, the Julian Date was 2452920.22917. For a calculation of the current (or any other) Julian Date, use this external link.
the number of elapsed days since the beginning of a particular year. For example, in this usage, the Julian date for the calendar date of 1998-02-28 would be day 059.
a Julian day number with a fractional component representing the time elapsed since the start of the day (or rather the nychthemeron, the day-and-night)
a way of referring to a date and is an alternative to YYYYMMDD
A date written in the format yyddd, where yy = current year, ddd = day of year. 84001 = January 1, 1984, 85365 = December 31, 1985. (Numbers will vary if Leap Year)
A Julian Date (JD) is a floating-point number rounded to the nearest Julian Day with the fraction of the day which has passed since 12 noon Greenwich Mean Time (UT or TT) of that day. This should not be confused with the "Julian Calendar" or the "Julian Date." Julian Dates are commonly used to simplify astronomical calculations.
The interval of time in days (and fraction of a day) since Greenwich noon on Jan. 1, 4713 BC. The JD is always half a day off from Universal Time, because the current definition of JD was introduced when the astronomical day was defined to start at noon (prior to 1925) instead of midnight. Thus, 1995 Oct. 10.0 UT = JD 2450000.5.
An algorithm for expressing a date in integer form, using the SQL function JDATE. Julian dates allow additional arithmetic functions to be performed on dates.
The numeric day of the year that the return or document is numbered. The sixth, seventh, and eighth digits of the DLN represent the Julian date.
A date that is in the format of the year and the number of the day in the year where January 1st is day 1 and December 31st is day 365, unless the year is a leap year in which case December 31st is day 366. This is shown abstractly as dddyy (01596 is the 15th day of 1996) or as yyddd (96015).
A date calculated by number of days elapsed since January 1, 4713 BC.
A date format that contains the year in positions 1 and 2, and the day in positions 3 through 5. The day is represented as 1 through 366, right-adjusted, with zeros in the unused high-order positions. For example, the Julian date for April 6, 1987 is 87096.
Julian dates run serially throughout the year. 1st January is always 001 and 31st December is 365 (366 if a leap year) 74
A date based on the Julian Calendar. It refers to the date based on the number of days in a year. The Julian date consists of five digits. The first two identify the year. The last three identify the day of the year (from day 1 to day 365). For 1999 the Julian date begins with 99, for 2000 it begins 00. Julian date 00023 would be Jan 23, 2000. Julian date 99345 would be Dec 11, 1999.
A three digit number designating the day of the year. Examples: January 15th has 015 as its Julian date. November fifteenth is 319. Julian dates are often used for stamping date on workpiece parts.
The number of days which have elapsed since 12:00 GMT on Jan. 1, 4713 BC. This system of numbering by consecutive days gives a calendar independent of month and year and is used for analyzing periodic phenomena. This system, devised in 1582 by J. Julius Scaliger and used most extensively by astronomers, has no connection with the Julian calendar other than the similar name.
n. 1. A date expressed as the number of days elapsed since January 1, 4713 B.C. (on the Julian calendar)-- for example, 2,450,000 for October 9, 1995 (Gregorian). Julian dates are useful for finding elapsed times between events that may be many years apart, as in astronomy. The starting point is the beginning of the Julian Period, defined in 1583 by Joseph Scaliger as the coincidence of several cycles based on the Julian calendar. See also Gregorian calendar, Julian calendar. 2. Often (but incorrectly), a date expressed as the year and the number of days elapsed since the beginning of the year--for example, 91.13 for January 13, 1991. Acronym: JD.