Re: Date Format in SQL

[Robert Rogerson <rogersonra@xxxxxxxxx>]

Hey Duane, did you try from the menu in Run SQL Scripts Connection->JDBC
Configuration->Format tab?  You can set the date format there....

Rob

On Thu, Dec 10, 2020 at 10:48 AM Duane Scott <dscott@xxxxxxxxxxx> wrote:

> I've done a bit of research and cannot figure out how to change the
> default date format for queries in Run SQL Scripts using RDI.
>
> I'm used to ISO formats as the default, but somehow it's now set at
> MM/DD/YY (MDY) and all my queries over a file with a "valid" date comes
> back with a warning that there's and invalid date if the date field is
> selected.
>
> We use a date of '9999-01-01' to signify a non-ending enrollment period,
> which is of course not a valid date for MDY format.
>
> How did it change from ISO to MDY?  And how do I change it back?
>
> CONFIDENTIALITY NOTICE: This electronic message transmission is intended
> only for the person or entity to which it is addressed and may contain
> information that is privileged, confidential or otherwise protected from
> disclosure. If you have received this transmission, but are not the
> intended recipient, you are hereby notified that any disclosure, copying,
> distribution or use of the contents of this information is strictly
> prohibited. If you have received this e-mail in error, please contact NALC
> Health Benefit Plan at 703-729-4677 and delete and destroy the original
> message and all copies.
>
> --
> This is the Rational Developer for IBM i   (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/wdsci-l.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com