One internal format of date/time information is the MI 8-byte Standard Time
Format (also refered to as *DTS in some cases). This format will "loop" at
roughly May 10 2071 at 11:56:53. So the last "full" date that can be
represented with this time format is May 9. I have to assume CVTDAT used
this format internally.

Assuming this is a CL program problem then the Convert Date and Time Format
(QWCCVTDT) API might be worth looking at. The API, depending on the format
specified, can support dates thru Dec 31 9999. The format *DTS is
documented by the API as being limited to a max date of May 10 2071.

Bruce Vining

On Thu, Nov 12, 2015 at 10:45 AM, <rob@xxxxxxxxx> wrote:

There is no "sliding scale" on the date conversion. IOW, there is no
intention to adjust this as the years progress.
And it's pretty limited, even if you are going from 8 digit to 7 digit.

From the help.
Only valid dates can be converted. If either the from-format or the
to-format use only 2 digits to specify the year (for example, *MDY,
*DMY, *YMD, or *JUL), valid dates are in the range of January 1,
1940, to December 31, 2039. Otherwise, valid dates are in the range
of August 24, 1928, to May 9, 2071. If the year is specified with
only 2 digits, years in the range of 40 to 99 are assumed to be 1940
to 1999; years in the range 00 to 39 are assumed to be 2000 to 2039.
The command works in conjunction with the QLEAPADJ system value.

Now why it can only convert *YYMD from 20710509 into *CYMD 1710509 and not
*YYMD 20710510 into *CYMD 1710510 escapes me.

I think I would avoid this crap and start using 'real' date columns.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Vinay Gavankar <vinaygav@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 11/12/2015 11:20 AM
Subject: CVTDAT Date limits
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Hi,

What are the current date limits (V7R1) for CVTDAT converting from or to
*CYMD format?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.





This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2019 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].