Just a small thing, but there's no such thing as a "julian day of the year". The Julian calendar is a whole seperate thing, so a julian day is a julian day. Day of year (DDD in oracle) is the day of the year, no relation to Julian at all.
if the "thedatecol" column, is already a date use it directly. An oracle date column always contains the entire date. If you stored a day-of-the-year into a date column, the date will already contain month, day, year, hour, minute, and second information and can be accessed directly. To test it, try the following select.
select to_char(thedatecol,'DD-MON-YYYY HH:MI.SSAM') FROM MYTABLE;
Originally Posted by sching
Thanks shoblock and beilstwh - tried the following sql and it works !
select to_date(to_char(thedatecol),'ddd') from mytable.
Last edited by beilstwh; 07-15-04 at 16:39.
You do not need a parachute to skydive. You only need a parachute to skydive twice.