Re: DDS date field & SQL

[Alan Campin <alan0307d@xxxxxxxxx>]

Where are you executing the SQL. STRSQL, Ops Nav, Embedded SQL? If you go
into STRSQL and do a F13 and change the date format to *ISO and execute the
SQL statement does it work?

On Tue, Sep 29, 2015 at 11:24 AM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
wrote:

> I don’t know.  That's not something I've ever really considered.  You
> think my problem is because the original developer put that DATFMT(*ISO)?
>
>
>
> -----Original Message-----
> From: Alan Campin [mailto:alan0307d@xxxxxxxxx]
> Sent: Tuesday, September 29, 2015 12:19 PM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: Re: DDS date field & SQL
>
> What is the date format you are using with SQL? *ISO. If you are using
> *YMD, *MDY, etc it is going to choke.
>
> --
> 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.