Re: Date in ESQL/C

En Adam Gagatek va escriure el dia 4 Jul 2000, a les 16:43: > I have short question > > I want to retrieve in select statement date as a string > with four digits in year eg: > > select some_date into :my_date from some_table where ... > > I have date in such format: "99-05-05" but I'd like > to have "1999-05-05" > > What should I do? > It is possible to do this automatically? > I have dates like 1900 as well as 2000... > > > Is there any variable or option responsible for that? > > > Adam > Check you environment variable DBDATE. If you want to see the century use: DBDATE=Y4MD/ (See Informix Guide SQL ) --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de 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 ---------------------------------------