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

You should be able to set the DBDATE variable to y4md, you can also override the date format Oracle is expecting for example if the date out of informix is in mm/dd/yyyy, in Oracle you would issue the following statement: alter session set nls_date_format = 'mm/dd/yyyy' On 30 Oct 1997 11:28:05 -0500, nnob@loc.gov (Nick Nobbe) wrote: >Pranil, > Try plain ol' sql: > > unload to myfile > select col1,col2, year(datecol) || month(datecol) || day(datecol ..... > from mytable > where ....> > You may have to play with it. You could also unload the data and >use good ol' Unix utilities (you may see them disappear when you >move to NT) like sed and awk. > > However, if you prefer a programming solution ...... > >Yours, > Nick > ********************************* > Nick Nobbe, Library of Congress > NLS/BPH > mail: nnob@loc.gov > ********************************* > >On 28 Oct 1997, 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. >> >> >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Arroyo Arroyo Consulting javiera@arroyoc.com http://www.arroyoc.com