DATES MANAGEMENT ON C-ISAM 5.00

We have an Informix database. The version is: C-ISAM 5.00.UC1 The SQL interface version is: 7.20.UD1 THIS IS THE ".profile" for user INFORMIX ************************************************************ ********************** PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:/usr/informix /data/informix.upg/bin:. TERMCAP=/usr/informix/etc/termcap TERM=wyse60 INFORMIXSERVER=icon_db INFORMIXDIR=/usr/informix/data/informix.upg DBDATE=dmy4/DBTEMP=/usr/informix/data/tmp export PATH TERM TERMCAP INFORMIXSERVER DBDATE DBTEMPINFORMIXDIR ************************************************************ ********************** Our problem is: if I run the following query (where podet is a dummy table): select date("10/11/99") from podet I have: 10/11/1999 but if I run: select date("10/11/00") from podet I have: 10/11/1900 Is there any help you can give me? Thank you * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful