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

Posted in 1997

bala peddi — Tue, 28 Oct 1997 17:39:28 -0500 — source: Informix-list mailing list archive (1991-1998)

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. > U have to use esql/c program and get the data into integer variable convert it into yyyymmdd using unix system call "localtime()" and c printf() I U want code feel free to contact me through email BALA PEDDI bala.peddi@fmr.com