Re: Informix Exporting Date Problem..HELP!!!!

Pranil wrote: > > I am migrating a database from Informix to Oracle RDB but having problem with > the date. I can upload date as yyyymmdd which I can then convert to DATE VMS, > but the problem is extracting the data from Informix with the date as yyyymmdd > eg. 19961031. How can I do this ??? Is there anyway in Informix I can do a > select statement and have the date displayed in this format (I believe this is > the ansi format) ? > > Please help. > THanks, > > Pranil Singh. > There is DBDATE environment variable. In sh, ksh, bash or zsh: DBDATE=Y4MD0 ; export DBDATE In csh: setenv DBDATE Y4MD0 HTH Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+