Date types in XE

[jill_maclaurin]

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]

XE is a julian type date field
----- Original Message -----
From: "jill_maclaurin" <[email protected]>
To: <[email protected]>
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

 

[jill_maclaurin]

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

 

[SSAJAROFF]

Jill :

On Xe, all use the Julian format CYYDDD.

Sebastian Sajaroff




B7321 to Xe, NT/W2K/SQL
JAS, Interoperability
MCDBA,MCP+I,MCSE,Citrix Admin
[email protected]
Grupo ASSA - Application Software SA

 

[Carl_Fisher]

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

 

[jill_maclaurin]

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

 

[daneppich25]

Re: RE: Date types in XE

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