Re: DATE format problem

Posted in 1998

Sujit.Pal@alltel.com — Mon, 15 Jun 1998 06:32:57 -0500 — source: Informix-list mailing list archive (1991-1998)

Jung-Hui You can set the environment variable DBDATE=MDY4/ for mm/dd/yyyy. HTH Sujit Pal ______________________________ Reply Separator _________________________________ Subject: DATE format problem Author: "Jung-Hui Cheng" <cheng@dbtel.com.tw> at internet Date: 6/13/98 9:32 AM I have migrated the database from Informix Online 7.12 to Online 7.22 recently. Because there are many tables contain 'date' data format and the date format like "MM/DD/YYYY" in the original database. The new engine told me that format is incorrect. Does anyone know how to set the variable "DBDATE" or "GL_DATE" on Informix 7.22 for the same date format ? Thanks.... Jung-Hui Cheng cheng@dbtel.com.tw DBTEL Incorporated.