[OpenSER-Devel] Again Oracle problems
Martin.Gruber1 at infineon.com
Martin.Gruber1 at infineon.com
Tue Aug 7 10:50:24 CEST 2007
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: devel-bounces at openser.org [mailto:devel-bounces at openser.org] On
Behalf Of Victor Gamov
Sent: Monday, August 06, 2007 8:48 PM
To: devel at openser.org
Subject: Re: [OpenSER-Devel] Again Oracle problems
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
_______________________________________________
Devel mailing list
Devel at openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
More information about the Devel
mailing list