• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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
XE is a julian type date field
----- Original Message -----
From: "jill_maclaurin" <jill.maclaurin@cognos.com>
To: <jdelistml@jdelist.com>
Sent: Tuesday, July 24, 2001 2:49 PM
Subject: Date types in XE


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?
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=1
7309



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix
 
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