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. 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. 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
__________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
