- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- about Julian date

Application Development Discussions

Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

about Julian date

Former Member

Options

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

06-20-2008 11:39 AM

1,313

What exactly julian date refers to? any example of the julian date?

i checked the previous forums... but they all refer to giving code related to converting the date from one format to another format? somebody pls enlighten me about julian date... what exactly it has to do with SAP and all? thank you.

- SAP Managed Tags:
- ABAP Development

1 ACCEPTED SOLUTION

Former Member

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

06-20-2008 11:50 AM

310

SRK

See the below example for the Julienne date format:

FORMAT is u2018Yearu2019 u2018Day of year u2018u2013 YDDD

July 4, 2007 equates to 7185

********Reward points if useful

Regards,

Kiran Bobbala

- SAP Managed Tags:
- ABAP Development

6 REPLIES 6

Former Member

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

06-20-2008 11:42 AM

310

Hi,

The Julian day or Julian day number (JDN) is the integer number of days that have elapsed since the initial epoch defined as noon Universal Time (UT) Monday, January 1, 4713 BC in the proleptic Julian calendar.[1] That noon-to-noon day is counted as Julian day 0. Thus the multiples of 7 are Mondays. Negative values can also be used, although those predate all recorded history.

Now at 19:45, Thursday June 19, 2008 (UTC) the JDN is 2454638. The remainder of this value divided by 7 is 4, an integer expression for the day of the week with 0 representing Monday.

The Julian date (JD) is a continuous count of days and fractions elapsed since the same initial epoch. Currently the JD is 2454637.3229167. The integral part (its floor) gives the Julian day number. The fractional part gives the time of day since noon UT as a decimal fraction of one day or fractional day, with 0.5 representing midnight UT. Typically, a 64-bit floating point (double precision) variable can represent an epoch expressed as a Julian date to about 1 millisecond precision.

A Julian date of 2454115.05486 means that the date and Universal Time is Sunday 14 January 2007 at 13:18:59.9.

The decimal parts of a Julian date:

0.1 = 2.4 hours or 144 minutes or 8640 seconds

0.01 = 0.24 hours or 14.4 minutes or 864 seconds

0.001 = 0.024 hours or 1.44 minutes or 86.4 seconds

0.0001 = 0.0024 hours or 0.144 minutes or 8.64 seconds

0.00001 = 0.00024 hours or 0.0144 minutes or 0.864 seconds.

Almost 2.5 million Julian days have elapsed since the initial epoch. JDN 2,400,000 was November 16, 1858. JD 2,500,000.0 will occur on August 31, 2132 at noon UT.

The Julian day number can be considered a very simple calendar, where its calendar date is just an integer. This is useful for reference, computations, and conversions. It allows the time between any two dates in history to be computed by simple subtraction.

The Julian day system was introduced by astronomers to provide a single system of dates that could be used when working with different calendars and to unify different historical chronologies. Apart from the choice of the zero point and name, this Julian day and Julian date are not directly related to the Julian calendar, although it is possible to convert any date from one calendar to the other.

Historical Julian Dates were recorded relative to GMT or Ephemeris Time, but the International Astronomical Union now recommends that Julian Dates be specified in Terrestrial Time, and that when necessary to specify Julian Dates using a different time scale, that the time scale used be indicated when required, such as JD(UT1). The fraction of the day is found by converting the number of hours, minutes, and seconds after noon into the equivalent decimal fraction.

The term Julian date is also used to refer to:

Julian calendar dates

ordinal dates (day-of-year)

The use of Julian date to refer to the day-of-year (ordinal date) is usually considered to be incorrect, however it is widely used that way in the earth sciences and computer programming.

- SAP Managed Tags:
- ABAP Development

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

06-20-2008 11:47 AM

310

Vishal, thank u.. i came across the exact information from wikipedia website...

but i wud like to know its relation with SAP..

- SAP Managed Tags:
- ABAP Development

Former Member

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

06-20-2008 11:50 AM

311

SRK

See the below example for the Julienne date format:

FORMAT is u2018Yearu2019 u2018Day of year u2018u2013 YDDD

July 4, 2007 equates to 7185

********Reward points if useful

Regards,

Kiran Bobbala

- SAP Managed Tags:
- ABAP Development

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

06-20-2008 11:53 AM

310

Kiran, u mean in 7185---> 7 refers to 2007 and 185 refers to the day of the year? am I right?

what is the default date format of SAP?

- SAP Managed Tags:
- ABAP Development

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

06-20-2008 11:56 AM

310

SRk,

You are correct. The last digit of the year will be the first character.

Generally SAP process the date fields in the format YYYYMMDD. Check it while debugging.

Regards,

Kiran Bobbala

- SAP Managed Tags:
- ABAP Development

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

06-20-2008 11:58 AM