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

Re: Converting dates to Julian Format

Williams, Kara wrote:

> 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!

I don't know about PeopleSoft, but for Oracle Julian date format use:

    to_char (date_value, 'DDD')    /* day of year (1-366) */

--
Steven Calvert
calvert@uleth.ca
University of Lethbridge
(403)329-2071