Adman wrote:
> Serge,
>
> Thank you for responding. Unfortunately I feel like I do not have the
> vocabulary to explain exactly what I am looking for so I thought I
> would give an example of the select process I did in our Informix
> environment.
>
> Column ord_rels_dt is defined as a date column.
>
> 1. select ord_rels_dt from iord
>
> 06/17/2003
> 07/29/2003
> 07/23/2003
>
> 2. export DBDATE=DMY4-
>
> 3. select ord_rels_dt from iord
>
> 17-06-2003
> 29-07-2003
> 23-07-2003
>
"DateTimeStringFormat CLI/ODBC configuration keyword"
http://publib.boulder.ibm.com/infoce...6d%61%74%22%20
It's part of the cli.ini configuration file on the client
I'm not sure whether teh client has a way to set it within a session.
But you can have different formats for different clients.

Cheers
Serge

PS: I'm no expert on the client side. So you'll need to dig from here or
hope someone else picks thsi thread.
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab