Re: CVTDAT Date limits

[Bruce Vining <bvining@xxxxxxxxxxxxxxx>]

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.