[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 [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
