Re: SQL PLUS question

This is realy an Oracle question belonging in one of the Oracle groups. However from the Informix side dbload can deal with day-month-year if you can make the month numeric. In that case you simply set the dbdate environement variable to DMY2- before you start dbload. If you can't make Oracle generate numeric month you can easily make a script (awk, sed, perl or whatever fits best) that does the conversion before the data is loaded into Informix. chalu kim <chalu@ivillage.com> wrote: :We are moving data from ORACLE to Informix; we are having a problem with :SQLPLUS while trying to dump the data to file. How can we control the :way SQLPLUS outputs a DATE type field. Currently when running a select :statement to output a DATE type field, it outputs in form of :DAY-MONTH-YEAR, EX: 27-JAN-97. Is there some way to have a DATE field :output in a format that INFORMIX dbload command could work with? :EX: MONTH-DAY-YEAR 01-27-97. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org