aparna p wrote: > > Mr. Ignacio: > Hello! I'm Aparna and I'm a fresher for SAP. I found > your query on the web & I'm now facing the same > problem. hope u've solved your problem successfully. > It'll be of great help for me if u can extend your > support in solving the same for me. > I tried to change the date_time_format thro command > line in DataBase Manager (with the command > 'param_directput date_time_format USA'). After > execution the date_time_format is changed to USA. (I > could see the parameter set to USA by giving the > command param_extgetall). But still the change is not > implemented in the Database Instances when I try to > work with them in SQL Studio.
The archive is full of answers concerning this: SQLStudio uses ODBC. ODBC has its own definition of date_and_time_format we have to take care for --> using SQLStudio (ODBC) will not use the date_and_time_format specified during installation (or param_directput), but the ODBC-format. > And one more help I need from u is I'd like to > transfer or shift my existing database in Oralce to > SAP. I tried to change the Oracle datatypes to > compatible datatypes in SAP. But when it comes to the > datatype DATE I'm lost. I couldn't find any data type, > which suits my requirement. For inserting date in > Oracle we used TO_Date( '11/20/2002 12:00:00 AM', > 'MM/DD/YYYY HH:MI:SS AM'). Is there any alternative > which I can adopt , so that I can get date data stored > in the required format. Use sqlmode Oracle, use TO_DATE and use the datatype date. Or use sqlmode INTERNAL and the datatype TIMESTAMP for definition and then change to sqlmode Oracle, because TO_DATE is not available in sqlmode internal and the predefined date_and_time_formats do not look as you want the format to be. > Could u pse explain me the step-by-step procedure u > followed to solve the problem (bcos I'm still a > fresher as informed earlier). > Thanking you in anticipation of your early response. > Hope I'm not giving u trouble. > Aparna Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
