Re: Date Format in SQL

["Jim Diephuis" <diephuis@xxxxxxxxxx>]

This really isn't an RDi question. In SQL scripts if you click on the 
Connection tab and select JDBC Configuration - Default you can go to the 
Format tab and change the date format.

Jim Diephuis 
IBM i Senior Managing Consultant 
Lab Services Power Systems Delivery Practice
phone: 507.253.1248 
e-mail: diephuis@xxxxxxxxxx 





From:   Duane Scott <dscott@xxxxxxxxxxx>
To:     "WDSCI-L@xxxxxxxxxxxxxxxxxx" <WDSCI-L@xxxxxxxxxxxxxxxxxx>
Date:   12/10/2020 09:48 AM
Subject:        [EXTERNAL] [WDSCI-L] Date Format in SQL
Sent by:        "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx>



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.