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')
Received on Mon Nov 25 2002 - 13:00:13 CST
