Re: Julian dates in PeopleSoft

[Ken Gartman <osmium@EROLS.COM>]

Hi there, Dean!
        Please don't be casual in differentiating "Julian Day" (the
number of a day in a year) from "Julian Date" (the number of days since
a specifice starting date.)

        Julian days range from 1 to 366.  February 28th is always Julian
day 59.  March 1st is Julian day 60 some years, and Julian day 61 during
other years.  For any day of the year after February, the Julian day
cannot be determined without knowing if it is a leap year or a regular
year.


        There is no need to write your own function.  Peoplesoft has a
good set of date manipulation routines, and ORACLE has a better one.

                        Happy computing,
                        Ken Gartman


MORRIS, Dean wrote:
>
> Dear All,
>
> I'm currently working on a PeopleSoft Financials v7 implementation on an
> Oracle database.
>
> We're trying to find a standard function that will translate a Julian
> date into standard date format.  ie. a number between 1 and 365 and
> convert it to a 31-12-1997 type date.  This logic is fairly easy to
> write, but I was hoping to be able to use a standard SQR function to do
> it.  There does not seem to be one in the standard SQC files.
>
> Can anyone help?
>
> Thanks in advance.
>
> Dean.