Hi, Thanks for your reply. In Oracle you do not have the DATETIME format. I use libsqora.so.10.1. I thinks the insert string is in the usrloc Module, not in the unixodbc module, or am I false?
Kind regards martin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor Gamov Sent: Monday, August 06, 2007 8:48 PM To: devel@openser.org Subject: Re: [OpenSER-Devel] Again Oracle problems [EMAIL PROTECTED] wrote: > Hi @ all, Hi Martin! > I have set up my Oracle DB together with OpenSER. It is running well, > but I have problems with inserting Data from usrloc. The dateformat is > like this: YYYY-MM-DD HH:MM:SS from OpenSER but my DB "wants" it Like > this: DD-MM-YYYY HH:MM:SS Does anybody know how to set it up in ORACLE > to run well. I tried it with alter session set nls_date_format = > 'YYYY-MM-DD'; But it is not running! > > I do not want to change it in the module, as I always have to change > it, after an update or newer version! YYYY-MM-DD HH:MM:SS is ODBC-like DATETIME format. If I understand correctly you must set DB-specific datetime format in Oracle driver config (it it possible to you driver) Also it may be possible to update unixodbc module to use "escaped ODBC DATETIME format" like this {ts 'yyyy-mm-dd hh:mm:ss'} (see at http://msdn2.microsoft.com/en-us/library/ms190234.aspx) Needs to test. -- CU, Victor Gamov _______________________________________________ Devel mailing list Devel@openser.org http://openser.org/cgi-bin/mailman/listinfo/devel _______________________________________________ Devel mailing list Devel@openser.org http://openser.org/cgi-bin/mailman/listinfo/devel
