Date types in XE

When XE is installed (not via an upgrade), are the date fields still stored as julian? Or is JDE using an actual data/time field? Is this the same thing for an upgrade too? Or does the julian format get imported into XE?

Thanks in advance,
Jill
 

jeremey_garcia

VIP Member
Does that mean that all dates are stored as numeric? If so, is this format the same as World (ie 98201) or is it like a Gregorian (ie 19980720)?

thanks in advance,
Jill
 

Carl_Fisher

Well Known Member
See earlier posts on this issue.

Basically the JDE date is a 6 digit number - YYYDDD, where YYY is year since
1900, and DDD is the day in the year from 001 to 365/366

so today's date is 101207.



OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + 4 NT PC's for development
 
Re: RE: Date types in XE

Ok, I get it now. But, that leaves me with one last question....I am using a demo database (Access mdb), and all the dates are MM/DD/YYYY. Is this just because this is a demo?

Again, thanks for the help!
Jill
 
Top