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,
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 :

On Xe, all use the Julian format CYYDDD.

Sebastian Sajaroff

B7321 to Xe, NT/W2K/SQL
JAS, Interoperability
[email protected]
Grupo ASSA - Application Software SA
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!
Re: RE: Date types in XE

That is a setting on your local machine if I understand you correctly.