Re: Reports 3.0 / Alter Session
Date: Tue, 16 Mar 1999 15:57:28 +0100
Message-ID: <36EE7158.6CD36D38_at_tui.de>
Hello,
I think the best way is to use a to_char-function in your query:
select to_char(date_field, format_string) from table;
Greetings
R. Bielefeld
"F. Schmitt" wrote:
> Hi there,
>
> I'd like to switch the nls_date_language (or nls_language) parameter for
> some weekday output of my report - in the online help i found a hint to
> switch the nls_standards, but they wouldn't work with reports but nls_sort.
>
> THe environment var I don't want to use...
>
> so I tried to call dbms_session.set_nls('nls_date_language', value) -
> exception. didn't know which one. so I wrote a stored proc to set the param
> and after setting it I read the value out of v$nls_parameters - to verify
> that it is set to the new value. That worked (the setting), but my output
> was still in the wrong (server-standard) language...
>
> What else could I try?
>
> We use Oracle Server 7.3 on (sorry) WindowsNT Server 4.0, Client Windows NT
> 4.0 also. Developer/2000 V2.1, Reports 3.0.5.8.0
Received on Tue Mar 16 1999 - 15:57:28 CET