Converting dates to Julian Format -Reply

[Cecilia Bigley <cbigle@CORP.ATL.COM>]

Kara -

Using Oracle, you can use the function
TO_CHAR('DD-MON-YY',J) where J is the Julian date
(days since Decmber 31, 4713 B.C.).  I hope this helps.

Cecilia Bigley

>>> "Williams, Kara" <KWilliams@CAROLINAS.ORG>
07/28/98 05:42am >>>
I need to convert a date to julian format in my sqr.  I am
working with
PeopleSoft and was wondering if there is a delivered SQC
which will do
this conversion.  I am also using Oracle so if anyone
knows if Oracle
can handle the conversion please let me know.  I
appreciate your help!