[OpenSER-Devel] Again Oracle problems

[Victor Gamov]

Martin.Gruber1 at infineon.com 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