Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem concerning date using oo40
In article <33a30017.0211250200.28d9dbf5_at_posting.google.com>,
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
It's now working with to_char, thanks for your help Received on Tue Nov 26 2002 - 04:33:30 CST