This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Oracle 6 digit date ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle 6 digit date ?" Watch "Oracle 6 digit date ?" New topic

Oracle 6 digit date ?

James Clarke
Ranch Hand

Joined: Oct 04, 2004
Posts: 148

I came accross a date format defined as number(6,0) used in a JD Edwards database.

A number such as 104147 is apparently year 2004, 147th year...

Does Oracle 8i have a function that can convert this to date type ?

thanks in advance,

Chris Hendy
Ranch Hand

Joined: Mar 04, 2006
Posts: 98
No, you would have to write your own.

By the way, do you not mean 104147 is year 2004, 147th day?

If so, you would do something like


where v_jd_date is your JD Edwards date-as-a-number

[ November 11, 2006: Message edited by: Chris Hendy ]
[ November 11, 2006: Message edited by: Chris Hendy ]
subject: Oracle 6 digit date ?
Similar Threads
using parse() from DateFormat
Get WeekStart Date & End date by Week Number in java
date calculation inside select clause
SQL Show Previous Month Date Question
How do you recycle a Oracle Sequence Number