Re: Date Format

En Frank Wehrle va escriure el dia 24 Jul 2000, a les 21:50: > Hi > > Is there a possibility to enter Date datatypes in differnet ways in the > Database? > I don't want to use the environment variables, because I have no > influence in the settings on the end-maschine. > > What I'm looking for is something like the TO_DATE() funktion in ORACLE. > > The problem that I have is, when inserting dates in the Table using jdbc > I have to use the format 'YYYY.MM.DD' but if I use a direct input I have > to use 'MM.DD.YYYY'. It's the same Database, the same user, the same > table, just accessed direct or with jdbc. > > Thanks in Advance.... > Frank > Use the environment variable DBDATE at your client (application) box. If you want enter dates in format DD/MM/YYYY before start your java application set DBDATE=DMY4/ Informix JDBC driver support GL_DATE DBDATE and DBCENTURY environment variables to format i/o dates. I hope this helps --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes d'Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------