[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Julian dates in PeopleSoft

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.