× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Yes, you're exactly right. The internal representation is what matters, not
the external representation.

On Thu, Aug 5, 2010 at 10:19 AM, sjl <sjl_abc@xxxxxxxxxxx> wrote:

Thanks for all responses.

I have not used date fields as often as I would like.

In JDE World software [which is my specialty], dates are stored as 6.0
numeric values in a psuedo-Julian value - dates are stored as CYYDDD. In
this representation, the first digit represent the century [when C=0,
century = 19, when C=1, century = 20], followed by the standard julian date
value.

Example:
The value 110001 is used to represent January 1, 2010.

** Another general question ***

When comparing /date/ fields, does it matter what format they are in? For
example, if I have a date field that is DATFMT(*JIS), can I compare it
successfully to a date field that is in another format, such as *ISO?

In other words, is the internal representation of a date field the same
[regardless of format], and does the DATFMT simply represent the way that
it
will be displayed for human-readable purposes?

Regards,
sjl






--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.