Re: Problem concerning date using oo40

From: Charlie & <root_at_bakka.org>
Date: 26 Nov 2002 08:56:56 GMT
Message-ID: <slrnau6duk.5sk.root@bakka.org>

In article <1ruE9.95$xI5.7966875_at_newssvr21.news.prodigy.com>, Karsten Farrell wrote:

> Alexandre CHRIQUI wrote:

>> I am trying to get the results of my date queries in the following
>> format :
>> 'dd.mm.yyyy,hh:mi:ss'
>> As I parse the char* result, the format has to be this.
>>
>> Could anyone tell me how to obtain a formatted result ?
>>
>> I tried to set the NLS_LANG setting, and to use the to_char Oracle
>> function, with no effect
>>
>> Thanks in advance
>>
>> --
>> Alexandre CHRIQUI
>> bakka_at_omatis.com

> In your sql select statement:
> 
> to_char(mydate,'dd.mm.yyyy,hh:mi:ss')
> 

Hi,
I've just read in a oo4o README :
"SQL function TO_CHAR(date, fmt) cannot be used because the first argument must be a date in native Oracle format and OO4O only handles 'string dates'."

So which type should I use for the "mydate" parameter ?

Thanks

--
Alexandre CHRIQUI
bakka_at_omatis.com

Received on Tue Nov 26 2002 - 02:56:56 CST