Re: Julian Dates

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Thu, 07 Jan 1999 15:59:00 +0800
Message-ID: <36946944.5A63@bhp.com.au>

Pilsbury wrote:
>
> Hi all,
>
> Does anyone know how to deal with Julian dates in Pro*C?
> I am trying to convert some ESQL/C code which uses Julian dates in the
> format:
>
> yyddd where ddd is the number of days into year yy.
>
> Oracle doesnt deal with them in this way; does anyone know a way to get
> round this?
>
> TIA
>
> Pilsbury

Why not just use to_char/to_date to change them into any format you like and let Oracle do the math...

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Thu Jan 07 1999 - 01:59:00 CST