Re: Problem concerning date using oo40

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 25 Nov 2002 19:01:56 +0100
Message-ID: <31p4uukt1bt19mvkt2bo5buuusffdehmg6@4ax.com>

On 25 Nov 2002 02:00:34 -0800, bakka_at_noos.fr (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

You should post the exact NLS_LANG settings and the exact TO_CHAR function you have used. People here are not clairvoyant, obviously

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 25 2002 - 12:01:56 CST