Re: QCENTURY and other date-related system values

To the best of my knowledge, QDATETIME will return a valid date all the way
through the year 9999. More to the point, any date data type with a
4-digit year will correctly support any year up to 9999. The 54-99 and
00-24 century crap only applies if you are using date data types with a
2-digit year.

- Dan

On Thu, Jun 28, 2018 at 12:05 AM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Wed, Jun 27, 2018 at 7:20 PM, Dan <dan27649@xxxxxxxxx> wrote:

How about system value QDATETIME?
RTVSYSVAL QDATETIME returns a YYYYMMDDHHNNSSXXXXXX value. Substring the
first 4 bytes for the 4-digit year.

Hm. If that doesn't count as the canonical method (given the system
values available today), it should be. Certainly better than getting
QCENTURY involved. I kept glossing over this one because I didn't
realize it would be any better than the combination of QDATE and
QTIME. And yet it is! Better than both of them!

The documentation is still pretty adamant that the date range is
limited, though. I would think QDATETIME is subject to the same limits
as any of the other system values, just that it's formatted better and
has better precision. I'm really hoping the documentation I quoted in
my previous post is simply incorrect.

Thanks for the tip! I'm definitely going to use it!