Thanks for the quick answer, but there still are some questions. I have read the next lines on the reference manual:
"SQLMODE The specification SQLMODE <INTERNAL|ANSI|DB2|ORACLE> can be used to select the SQL mode [Page 39]. The default SQL mode is INTERNAL. The CONNECT option SQLMODE <INTERNAL|ANSI|DB2|ORACLE> is not allowed in programs. The appropriate precompiler option must be used to specify an SQLMODE other than INTERNAL." 1. The option SQLMODE is not allowed in programs, so all solutions only apply when working with SQL Studio and scripts ? 2. What is the precompiler option ? It means that we have to compile something of SAP DB ? Thanks one more time ! Ignacio. Hi Ignacio, you may want to try the Oracle mode for your statements. (See http://www.sapdb.org/7.4/htmhelp/81/ee4d3c596f0b26e10000000a11402f/content. htm) There are also several function defined by Oracle available (see http://www.sapdb.org/7.4/htmhelp/b4/034e3ce0f9fe3fe10000000a114084/content. htm), including TOD_DATE, TO_CHAR, TO_NUMBER to some extend. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 12, 2003 10:26 AM > To: [EMAIL PROTECTED] > Subject: to_date and migration from Oracle > > > Hello everybody, > > we are just starting with SAP DB and we have to migrate some intranet > applications from Oracle to SAP DB. The migration process > with export / > import of scripts goes well. The problem is within the > application, because > it extensively uses TO_DATE and TO_CHAR when works with date fields. > > Is there any quick solution, without change all SQL code ? > > Thanks in advance. > > Ignacio > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
