Re: INet American Date format

Alex McLintock writes: -> -> ->I (alexmc) asked: ->> } I have Informix SE and INet version 5 (for RS6000 AIX and MS Windows) ->> } The dates in the database are british format DMY/ ->> } But INet (or ODBC) is reading them as american MDY/ format. ->> } ->> } I have set the DB_Date variable in the INet setup to DMY/ ->> ^^^^^^^^ -> ->And: andy@tern.msk.su "Andrey Yu. Grachyov" writes: -> ->> I think the environmemnt variable is called DBDATE. Maybe that helps... -> ->Several people tell me this but I only filled in the dialog box ->in the INet configuration program. There is no box for "DBDATE" - but ->there is one for "DB_Date". So have Informix fucked up _again_? ->Shall I ammend the ini files by hand. DBDATE is a UNIX environment variable used by Informix. If you don't know how to set one, write and I would be happy to help you (at least on UNIX, someone else will have to help you with WINDOWS). Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205 Currently available from Prentice Hall, my new book (ok... my only book): Programming INFORMIX SQL/4GL: A Step-by-Step Approach (ISBN: 0-13-149394-9)